July 30, 2004 at 1:11 am
I'm fairly new to the DTS area, I have 8 tables in my database that I need to export/transfer to an Oracle database. I know there are lots of ways to do it but I would like to have all the insert statements generated so that I can run them to import the data to the Oracle database.
Is there any way I can have SQL server to generate all the insert statements for me for these 8 tables? Can this be done via DTS?
Any insight is appreciated!
July 30, 2004 at 1:59 am
If you use the Import/Export wizard you can create a package that will generate the export of all the data into the Oracle database. You can do this by hand as well but if you're new it sounds like this would achieve what you required with not too much learning. What it will generate is 8 Data transform tasks that will simply drop the data from database to database. If the tables don't yet exist on oracle you can select to have these tables created.
Julie
Viewing 2 posts - 1 through 1 (of 1 total)
You must be logged in to reply to this topic. Login to reply