Upgrading older databases to the RDB DSC 2 schema

Data Model > Available DSCs > Relational MR database (RDB) CDSC > Upgrading older databases to the RDB DSC 2 schema

RDB DSC 2 can read and write data in older databases that use the RDB DSC schema. For more information, see Relational MR Database CDSC schema.

Alternatively, you can upgrade older databases to the RDB DSC 2 schema by using the XP_CHANGESCHEMA extended stored procedure, which is built into the in UNICOM Intelligence Data Model. See instructions below.

You must also make sure that the associated .mdd file has a data source object set up for RDB DSC 2. This is generally created automatically when you use RDB DSC 2 to connect to the database, provided the .mdd file is opened in read-write mode. For more information, see Connecting to a relational MR database using RDB DSC 2.

To upgrade an older database to the RDB DSC 2 schema

1 First open DM Query: In Windows Explorer, go to the folder in which the Visual Basic .NET version of DM Query was installed. By default, this is:

[INSTALL_FOLDER]\IBM\SPSS\DataCollection\7\DDL\Code\Tools\VB.NET\DM Query

2 Double-click the DM Query.exe file. This opens the DM Query window.

3 Now connect to the old database using the .mdd file and RDB DSC 2: From the DM Query File menu, choose Open New.

This opens the Connection tab in the Data Link Properties dialog box.

4 From the Metadata Type list, select Intelligence Metadata Document.

5 Enter the Metadata Location, either by typing the name and location of the .mdd file, or by clicking Browse.

6 Select Open metadata read/write.

7 From the Case Data Type list, select UNICOM Intelligence Database (MS SQL Server) (read-write).

8 Specify the Case Data Location using an OLE DB connection string. For more information, see Connecting to a relational MR database using RDB DSC 2.

9 Enter the Case Data Project. Typically, this is the same as the database name.

10 Click OK.

11 Do one of the following:

To retain the old database tables, type the following in the SQL box and press Enter:

EXEC xp_changeschema

To delete the old database tables, type the following in the SQL box and press Enter:

EXEC xp_changeschema(True)

12 Close DM Query.

Provided you opened the .mdd in read-write mode, the new connection string will be written to a new data source in the .mdd file.