April 12, 2009 at 1:13 am
Hi all,
I have Oracle(10g R2) tables to be imported to sqlserver2005,
kindly help me in importing them correclty with proper data type
to sqlserver 2005.
What would be the best way to do so, I heard of ODBC or even Oledb drivers.
how to use them & which one will be better option.
Regards,
aak
April 12, 2009 at 9:32 am
If this is a single shot action (migration ?) it may be best to use Microsofts migration assistant for Oracle. It can be downloaded free from here :
www.microsoft.com/sql/migration/
This may even help you design your table for sql2005/2008 to be used with an integration server package later on.
Johan
Learn to play, play to learn !
Dont drive faster than your guardian angel can fly ...
but keeping both feet on the ground wont get you anywhere :w00t:
- How to post Performance Problems
- How to post data/code to get the best help[/url]
- How to prevent a sore throat after hours of presenting ppt
press F1 for solution, press shift+F1 for urgent solution 😀
Need a bit of Powershell? How about this
Who am I ? Sometimes this is me but most of the time this is me
April 13, 2009 at 5:54 am
thanks, I have downloaded this software,
steps
1. connected to oracle
2. connected to sqlserver
3. created the user in sqlserver same as oracle one.
4. selected to tables in the oracle to be migrated to sqlserver
when I click convert schema it it getting hanged, and not able to proceed from here.
plz help me, some how I am able to create the blank table in sqlserve with this tool,
but how to transfer the data.. can you plz help me.
April 13, 2009 at 6:42 am
So you were able to create the tables (please create them in their own database, and not in any of the system databases (master, msdb, tempdb, model))
Maybe using the GUI will be the easiest way:
Open Management studio, connect to the sqlserver instance, open the object browser,
rightclick on your database and select Tasks / import data
This will launch a wizard and that should get you your data.
Johan
Learn to play, play to learn !
Dont drive faster than your guardian angel can fly ...
but keeping both feet on the ground wont get you anywhere :w00t:
- How to post Performance Problems
- How to post data/code to get the best help[/url]
- How to prevent a sore throat after hours of presenting ppt
press F1 for solution, press shift+F1 for urgent solution 😀
Need a bit of Powershell? How about this
Who am I ? Sometimes this is me but most of the time this is me
April 13, 2009 at 6:58 am
Yes I am using my own database and not system created,
I am doing it in the same way, one by one table each time.
using DTS, very time consuming.
however I thought the tool would help me in saving time.
Regards,
aak
April 13, 2009 at 7:56 am
I haven't experimented with the migration assistant for oracle, but the one for access also has an option to migrate the data.
Johan
Learn to play, play to learn !
Dont drive faster than your guardian angel can fly ...
but keeping both feet on the ground wont get you anywhere :w00t:
- How to post Performance Problems
- How to post data/code to get the best help[/url]
- How to prevent a sore throat after hours of presenting ppt
press F1 for solution, press shift+F1 for urgent solution 😀
Need a bit of Powershell? How about this
Who am I ? Sometimes this is me but most of the time this is me
April 17, 2009 at 10:15 am
aakcse (4/13/2009)
Yes I am using my own database and not system created,I am doing it in the same way, one by one table each time.
using DTS, very time consuming.
How much volume you are trying to move??
however I thought the tool would help me in saving time.
Regards,
aak
Are you looking for saving time in development or in copying process!!! SSIS or DTS is very fast unless you have very huge amount of data.
April 19, 2009 at 1:53 am
Size is of 10gb, and 20 table to be imported to sqlserver
April 20, 2009 at 8:39 am
Are you sure it is hanging. A db that size would take some time to convert. Are you getting any kind of messages in the output.
Mike
“I know that you believe you understand what you think I said, but I'm not sure you realize that what you heard is not what I meant.”...Robert McCloskey
___________________________________________________________________
Viewing 9 posts - 1 through 8 (of 8 total)
You must be logged in to reply to this topic. Login to reply