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.
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.
3 In the DM Query window, connect to the old database using the .mdd file and RDB DSC 2: click File > Open New.
This opens the Connection tab in the Data Link Properties dialog.
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).
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.
See also