Data Model > Frequently asked questions > When using DTS to export to a relational MR database, why is only one table created instead of several?
 
When using DTS to export to a relational MR database, why is only one table created instead of several?
When I use DTS to export to a relational MR database, I can see only one table (VDATA) in the DTS wizard. I was expecting to see several tables (Variables, Responses, OtherData, and so on) which will be created in the SQL Server database.
VDATA is the name of the Data Model's flat virtual table and it is the only table shown in the DTS wizard. If you select Relational MR Database CDSC for the destination, the Relational MR Database CDSC will create the Variables, Responses, and OtherData tables in the database.
See also
How the UNICOM Intelligence Data Model works
Relational MR database (RDB) CDSC
Transferring data using SQL Server Integration Services
Creating a relational MR database from a Quanvert database
Frequently asked questions