Create Read Only Copy to Access Elliott Database скачать в хорошем качестве

Create Read Only Copy to Access Elliott Database

This is a Zoom meeting where we discuss with a user who wants to set up a read-only copy for reporting users to access. We demonstrate how to create a nightly backup copy of Elliott and explain the option to use Microsoft SSIS to replicate the Elliott database to MS SQL. Timestamp: 00:00 Introduction 01:17 Demo of setting up a large Elliott site 06:14 Copying data from one data folder to another 08:51 Creating the database 12:14 Scheduling the nightly copy 13:04 How to hide the backup company in Elliott 14:16 Why having a training company is a huge advantage 15:25 User shares his screen 16:29 Creating database E3P85DATA99 25:12 NTFS security settings for DATA_99 26:33 Hiding company 99 through password setup 28:16 Hiding company 99 in Elliott Control Center 29:07 Hiding company 99 on a different server 30:38 Discussion: Elliott uses a database, not data files 33:56 Accessing the Elliott database through SQL Server Management Studio 37:50 Discussion on using DTS (Data Transformation Services), now called SSIS 44:02 Why we prefer using ADO.NET to replicate data