Kbase 17893: Follow These Steps to Migrate a Progress Database to MS SQL Server
| Autor |
Progress Software Corporation - Progress |
| Acesso |
Público |
| Publicação |
21/08/2003 |
|
Status: Unverified
FACT(s) (Environment):
ODBC DataServer
FIX:
Follow these steps to migrate a Progress database to MS SQL Server:
1) Go to the dictionary > data admin > PRO/SQL menu.
2) Select 'Dump as Create table'.
3) Select the tables that you want to migrate.
This tool generates a file that can be run in the MS SQL
client to create your MS SQL Server database. The tool does
not migrate the data.
4) Connect to your new MS SQL Server database with Webspeed
Version 2.1 (in Progress Version 9.x, you are able to connect
with the 4GL client) and write code to create the records.
(Remote connections are not available until Version 9.x.)
5) Move the data over to MS SQL Server Database.