The samples in this topic demonstrate exporting data that has been collected using multiple versions. The samples use the Short Drinks sample database, but they can be adapted to run with any multiversion project. To run the samples, you need access to a SQL Server installation and appropriate user access rights.

Before you can run these samples, you need to restore the Short Drinks sample. For more information, see The Short Drinks sample. You may also need to change the Data Source property in the OLE DB connection string to reflect the name of the server you are using. For more information, see Connecting to a relational MR database using RDB DSC 2.

This sample shows how to select all versions of the metadata for an export to Quantum. For more information, see Exporting UNICOM Intelligence Interviewer - Server Data to Quantum using all versions.

This sample exports data for all versions at the end of your project. This uses all of the versions of the .mdd file and exports data collected with all of the versions to a new IBM SPSS Statistics.sav file. For more information, see Exporting UNICOM Intelligence Interviewer - Server Data to IBM SPSS Statistics Using All Versions.

This uses the output of the ListCategoricalVars.mrs sample as an include file to export Respondent.Serial and all of the categorical variables in the Short Drinks sample database. For more information, see Restricting the variables in the export. You can use the CategoricalsOnly.bat sample batch file to run the two files. For more information, see Sample batch files.

This sample exports UNICOM Intelligence Interviewer - Server data to Quantum in batches. You use this sample to export the first batch because it allocates new card, column, and punch definitions and creates a Quantum.dat file that can then be updated by mrInterviewNextBatchToQuantum.dms. This sample also exports a Quantum specification. For more information, see Exporting batches of UNICOM Intelligence Interviewer - Server data to Quantum.

This sample exports UNICOM Intelligence Interviewer - Server data to IBM SPSS Statistics in batches. You use this sample to export the first batch because it creates a new IBM SPSS Statistics.sav file that can then be updated by mrInterviewNextBatchToSav.dms or mrInterviewNextBatchNewVersionToSav.dms. For more information, see Exporting batches of UNICOM Intelligence Interviewer - Server data to IBM SPSS Statistics.

This sample is designed to be run after mrInterviewAllVersionsToSav.dms. It merges all versions of the project's metadata into the output metadata from mrInterviewAllVersionsToSav.dms. This means that wherever possible the alias names are reused. This sample does not filter the case data according to whether it has already been transferred. However, you could easily modify it to do so using a similar method to that used in the batch export samples. For more information, see Exporting UNICOM Intelligence Interviewer - Server Data to IBM SPSS Statistics Using All Versions.

This sample selects two versions of the metadata for an export and export only case data collected using those versions and their minor versions. For more information, see Selecting multiple versions.

This sample is designed for use when you want to export UNICOM Intelligence Interviewer - Server data to IBM SPSS Statistics in batches and there is a new major version of the metadata. Each new version must export to a new .sav file. You would use this sample for the first export using the new version before using mrInterviewNextBatchToSav.dms to export the second and subsequent batches collected with that version. mrInterviewNextBatchNewVersionToSav.dms extracts the most recent version of the UNICOM Intelligence Interviewer - Server project's .mdd file into a new metadata file so that the alias names used for the previous exports will be reused wherever possible. For more information, see Exporting batches of UNICOM Intelligence Interviewer - Server data to IBM SPSS Statistics.

This sample is designed for use when you want to export UNICOM Intelligence Interviewer - Server data to Quantum in batches. You would use this sample to export the second and subsequent batches. It queries the .dat file created by mrInterviewFirstBatchToQuantum.dms (and updated by previous runs of mrInterviewNextBatchToQuantum.dms) to find the record with the latest value of DataCollection.FinishTime. It then transfers from the UNICOM Intelligence Interviewer - Server data all records that have a later value than that record. Generally you can export each batch to the same .dat file. However, there are certain version changes that require special handling. For more information, see Exporting batches of UNICOM Intelligence Interviewer - Server data to Quantum.

This sample is designed for use when you want to export UNICOM Intelligence Interviewer - Server data to IBM SPSS Statistics in batches. You would use this sample to export the second and subsequent batches. It queries the .sav file created by mrInterviewFirstBatchToSav.dms (and updated by previous runs of mrInterviewNextBatchToQuantum.dms) to find the record with the latest value of DataCollection.FinishTime. It then transfers from the UNICOM Intelligence Interviewer - Server data all records that have a later value than that record. If you have previously run mrInterviewNextBatchNewVersionToSav.dms, you must change the names of the input .sav and .mdd files in this sample to match those output by mrInterviewNextBatchNewVersionToSav.dms. For more information, see Exporting batches of UNICOM Intelligence Interviewer - Server data to IBM SPSS Statistics.

This sample shows you how to select a single metadata version for an export and export only case data collected using that version and its minor versions. For more information, see Selecting a specific version.

This sample shows how to use the WScript.Shell object to get the timezone information from the registry and use it to convert the output of the Now function to UTC. For more information, see Filtering on the interview finish time.