I have the scripts to set up the tables on ms sql but I don't have oracle and I believe I need to have that set up with the data before I can think about importing it to ms sql.
Is that right?
aspdaddy
3:03 pm on Dec 31, 2005 (gmt 0)
Once you have the tables setup do normal DTS imports. DTS has OLEDB and ODBC Providers for Oracle so its no different from any other import - You just need an IP address (or server name if local), username, password and database name. Oracle uses PLSQL and SQL Server uses TSQL so functions, packages and procedures and some data types dont port too easily :(
Easy_Coder
3:55 pm on Dec 31, 2005 (gmt 0)
So I just need to install oracle; load the oracle tables then dts them over to ms sql then?
aspdaddy
5:21 pm on Dec 31, 2005 (gmt 0)
Where is the Oracle data you are porting? you dont need to install oracle, you just need to be able to connect to the Oracle database you are porting
Easy_Coder
12:23 am on Jan 1, 2006 (gmt 0)
I have the backup files from an oracle system
aspdaddy
1:09 am on Jan 1, 2006 (gmt 0)
I see, why not VPN in and run DTS on the live Oracle server? Save installing Oracle. If you do have to install it, make sure its the same version or higher or the backup wont work.
Easy_Coder
2:00 am on Jan 2, 2006 (gmt 0)
I don't have access to the oracle system. It's a catalog export from a manufacturer/partner.
