Hi All, We're currently in the process of moving a Solaris/Oracle (11g) based system to a Windows/MSSQL (2012) environment. While using Migrator should absolutely work, the fastest way would be to just import the Oracle DB into the new MSSQL DB and we'd prefer that. The problem here is, that there are two providers in MSSQL to import data from Oracle databases and both don't manage to import all data completely and correctly. The ".net Framework Data Provider for Oracle" doesn't copy views, but manages to import all data, but the views would be required for the AR server to function correctly. The "Microsoft OLE DB Provider for Oracle" does copy views as well, but doesn't set the correct data types when creating tables and thus fails to import data after some time. The question is: has anyone performed a migration from Oracle to MSSQL by just importing the database to the MSSQL server? Or should we just stick with the Migrator for this matter?
Regards Jan Hartung _______________________________________________________________________________ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org attend wwrug12 www.wwrug12.com ARSList: "Where the Answers Are"
