This program will test the conversion of ProvideX data files to SQL Server by copying the data for specified modules from select ProvideX data files. Note that this is a test program and does not make any permanent changes to the FACTS system.
When you first access Test Conversion to SQL Server (SMU815), the program displays a message indicating the above. Select OK to continue or Cancel to return to the FACTS SM SQL Conversion menu.
If you select OK, the system displays the following message:
Caution: This conversion requires that the ProvideX DataDictionary has the latest file definitions. If there have been any data file structure changes since the last time the Data Dictionary Update was run, you must run the Data Dictionary Update now. Would you like to run the Data Dictionary Update program now?
Select OK to continue and run the Data Dictionary Update program or Cancel to access the Test Conversion to SQL Server (SMU815) without running the Data Dictionary Update program.
Complete the following fields to run the Test Conversion to SQL Server (SMU815) program:
1. ODBC Data Source Name
The data source name being used for this company. Press F1 to test the connection.
2. Module
The module code for the module being converted. For example, enter SA for Sales Analysis.
3. Database Name
For the module specified above, enter the database name and directory location for the module’s database.
4. Log File
Enter the directory path and file name for the log file.
Press OK save the information or Cancel to discard your changes and return t the SQL Server Management Menu.