× Data Warehousing and Data integration

Re: Migrating from Oracle To MS SQL Server

  • Posts: 33
  • Thank you received: 0

Migrating from Oracle To MS SQL Server was created by Joe

Hi,

We have 200 hosted customers using Oracle 10 g databases that we are considering migrating to Sql server 2008.

Our product already supports Sql server 2008 and therefore we already have a blank Sql db with all keys, stored procs, triggers etc in place.

Therefore we are looking for a reusable solution that we could use to migrate the data (and ONLY the data) in an automated way with minimal hassle.

Ideally we would generate a csv/xml/sql table with source and target datasources and then press a button.

The integrity of the data is extremely important and therefore we would like some way (preferably automated) to validate that the data has transferred successfully.

I would be interested in all services you provide to aid our migration, this could be in a advisory role to guide us on the best direction to take with existing tools or some other way that you think may be more appropriate.

I am also interested in your experience in oracle to sql migration, including past migrations, data validation techniques and multiple migration experience.

Thanks for your time.
Joe
9 years 7 months ago #3165

Please Log in or Create an account to join the conversation.

  • Posts: 8064
  • Karma: 33
  • Thank you received: 507

Replied by admin on topic Re: Migrating from Oracle To MS SQL Server

Joe.

Thank you for the interest in our services.

We have experience and software which will help you to migrate the data.

There two possible ways to migrate

1 if we can connect to both Oracle and Sql server same time we can migrate data directly without any intermediate files.
2 If it is not possible we can export all data from oracle into text files and load them into SQL Server.

All migrations are logged so you will be able to see if it was completed successfully

Once development of migration package is completed it became an automated process

If you would like to migrate another database all you would need to do is adjust connection settings and run the package

In order to assist you with the migration can I ask you to answer following questions

1 How many tables have you got?
2 How big is you databases?

Can you email us blank database for SQL Server and a dump of oracle schema so we can estimate amount of work involved.
(If it is too big we can download it from ftp)

Best Regards,
Mike,
DB Software Laboratory
Mike
9 years 7 months ago #3166

Please Log in or Create an account to join the conversation.

  • Posts: 1
  • Thank you received: 0

Replied by ksri8580 on topic Re: Migrating from Oracle To MS SQL Server

Hello,
Thanks for your good explanation, Joe.Hoping for the best explanation for new topics

Regards,
Srija,
2 weeks 11 hours ago #20676

Please Log in or Create an account to join the conversation.

This site uses cookies. By continuing to browse the site, you are agreeing to our use of cookies