SQL Server Performance Forum – Threads Archive

Oracle Data Migration

Hi Guys..
I have redesigned an Oracle database to sql server with completely new structure.Now I have to migrate Oracle data to SQL server and synchronize both databases so that I can run application on both databases paralelly. So I thought of 2 ways of doing it but not sure,any suggestions from your side is appreciated. 1)Migrate data through DTS into temporary database of sql server,then from the temp DB script it out into my new DB Design manually through INSERT commands. How can I shedule this task so that it syncronizes with Oracle database. 2)Script out Oracle data into a text file and provide a link for my sql server machine to access that file and from that file script all the data into new design on regular shedule so that it syncronizes with Oracle databse. This is just my idea and not sure whether it works or not,I need help from the forum members.Thanks a lot. Thanks!
"He laughs best who laughs last"

http://vyaskn.tripod.com/oracle_sql_server_differences_equivalents.htm
http://www.microsoft.com/technet/prodtechnol/sql/2000/reskit/part2/c0761.mspx
for your information. Satya SKJ
Moderator
http://www.SQL-Server-Performance.Com/forum
This posting is provided â€œAS ISâ€ with no rights for the sake of knowledge sharing.

I have a question. Why you are not willing to transfer directly to SQL Server without using temporary database or text file. is it because of performance issue? Anyway with the second option(text file) there can be secuirty issues. as you are having them in the plain text. So I would like to go with number 1

Some more reading stuff:
http://support.microsoft.com/default.aspx?scid=kb;EN-US;280106
http://www.microsoft.com/downloads/…5A-CA42-4C83-B71F-0DCCF2F0EF18&displaylang=en
http://www.microsoft.com/downloads/…5E-2CFC-49AE-A184-5705ACF8591F&displaylang=en
—
Frank Kalis
Microsoft SQL Server MVP
http://www.insidesql.de
Ich unterstÃ¼tze PASS Deutschland e.V. http://www.sqlpass.de)

Dinesh How can I do that directly, as I already said that I have designed new DB with complete new structure

quote:Originally posted by dineshasanka I have a question. Why you are not willing to transfer directly to SQL Server without using temporary database or text file. is it because of performance issue? Anyway with the second option(text file) there can be secuirty issues. as you are having them in the plain text. So I would like to go with number 1

Thanks!
"He laughs best who laughs last"

does it means that new DB has a completely different from the Oracle database. if so then using DTS is bit difficult.

yeah my new DB is different. I mean I have normalized all tha tables and now the structure is like shuffling all the coulmns and tables. If you say DTS is difficult, is there any other way I can migrate data,Any Help? Thanks!
"He laughs best who laughs last"

This is no trivial task. I would see that I get the data out of Oracle as much normalized as possible according to your new structure and then probably write some script in a scripting language that your familiar with to generate new text files to import into SQL Server. —
Frank Kalis
Microsoft SQL Server MVP
http://www.insidesql.de
Ich unterstÃ¼tze PASS Deutschland e.V. http://www.sqlpass.de)

]]>