Copying a UNICOM Intelligence database to another location

Developer Documentation Library > Data Model > Accessing the UNICOM Intelligence Data Model > Working with the Case Data Model > Accessing case data from third party applications > Transferring data using SQL Server Integration Services > Copying a UNICOM Intelligence database to another location

For information on working with the SQL Server Import and Export Wizard, see:

http://technet.microsoft.com/en-us/library/ms141209(SQL.90).aspx

This topic shows you how to use SSIS to copy a UNICOM Intelligence SQL Server database to another database, for example, in another location.

1 From the Windows Start menu, choose Programs > Microsoft SQL Server > SQL Server Management Studio

2 Right-click the appropriate database and select Tasks > Import Data.

This opens the first page of the SQL Server Import/Export wizard.

3 Click Next.

This opens the Choose a Data Source page of the SQL Server Import/Export wizard.

4 From the Data Source list, select Microsoft OLE DB Provider for SQL Server.

5 Enter the Server name and select the Database that you want to copy.

6 Click Next.

This opens the Choose a Destination page, which parallels the Choose a Data Source page.

7 From the Destination list, select Microsoft OLE DB Provider for SQL Server.

8 Enter the destination Server.

9 Do one of the following:

▪Select an existing Database.

▪From the Database list, select <New>, then enter the Name, Data file size, and Log file size, and click OK.

10 Click Next.

This opens the Specify Table Copy or Query page.

11 Select Copy objects and data between SQL Server databases.

This step is important: if you do not select this option, the database will not be usable with the UNICOM Intelligence Data Model.

12 Click Next.

This opens the Select Objects to Copy page of the SQL Server Import/Export wizard.

13 Accept the default options and click Next.

This opens the Save, Schedule, and Replicate Package page of the SQL Server Import/Export wizard.

14 Select the options you require and click Next.

15 If you chose to save the SSIS package, this opens the Save SSIS Package page. The details on this page depend on whether you chose SQL Server or Structured Storage File on the previous page. Enter a Name, Description, and the other details that are required for the SSIS package and then click Next.

16 Click Finish.

Requirements

UNICOM Intelligence Data Model

Microsoft SQL Server