This program converts selected ProvideX data files to SQL Server by copying the data for specified modules from select ProvideX data files.
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.
When you first access Live Conversion to SQL Server (SMU815), the program displays a message indicating the following:
Yes, the system displays the User Management (SME900) program, where you are able to see the users on the system.
The option to lock out all users is automatically set. When all users are out as indicated by the browser in the lower portion of User Management, exit the program, and the system displays the Live Conversion to SQL Server (SMU815) screen.
Note that the API Toolkit sessions will appear in the User Management (SME900) program. The ProvideX Web Server and/or the API Polling (SMU954) program must be stopped manually before you will be allowed to proceed.
Select No to return to the FACTS SM SQL Server Management Menu.
Complete the following fields to run the Live 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 Conversion menu.