Monday, October 8, 2007

Efficient ways to move a database from ORACLE to SQL Server 2005

Build a testing SQL server;
Create the databases, tables, views, indexes, and stored procedures according to ORACLE environment;
Import some data into the testing SQL Server;
After you successfully test it, you could do the following to move the database in ORACLE to the production server.

Run scripts on the production server to build all tables, views, and stored procedures;
Schedule one or more jobs to move all data from ORACLE databases to the new databases on production server;
Build all indexes, and update the statistics on all tables.