January 7, 2011 at 11:05 am
Hello Friends
I want to import 150 tables from the oracle 8i but when i tried it with the SSIS or import export i do get the tables with all the columns but the constraint like primary key and foreign key are not imported. I want them with the columns so that the users can use them for reporting by putting the joins.
So is there any way to use SSIS for my purpose?
Thanks
January 9, 2011 at 6:46 am
rd2718 (1/7/2011)
Hello FriendsI want to import 150 tables from the oracle 8i but when i tried it with the SSIS or import export i do get the tables with all the columns but the constraint like primary key and foreign key are not imported. I want them with the columns so that the users can use them for reporting by putting the joins.
So is there any way to use SSIS for my purpose?
Thanks
SSIS can move the data between two tables, but you are responsible for creating the metadata (aka constraints et cetera).
Doesn't Oracle have a tool or something to script out those 150 tables with CREATE statements so that you can create the tables on SQL Server with constraints in place? After that, you can move the data with SSIS.
Need an answer? No, you need a question
My blog at https://sqlkover.com.
MCSE Business Intelligence - Microsoft Data Platform MVP
January 10, 2011 at 3:36 pm
Try Microsoft SQL Server Migration Assistant for Oracle.
You can download it and see if it works for you.
Viewing 3 posts - 1 through 2 (of 2 total)
You must be logged in to reply to this topic. Login to reply