Hi, Do a fresh install, import the definitions (maybe using Migrator).
But use RRR|Chive instead to move the data. It is faster and more robust in this regard, and is designed to handle a high volume of records. Documentation, no login required: https://www.rrr.se/c/doc/rrrchive/?arslist Download and configuration: https://www.rrr.se/cgi/rrrchive/main?arslist Best Regards - Misi, RRR AB, http://www.rrr.se (ARSList MVP 2011) Products from RRR Scandinavia (Best R.O.I. Award at WWRUG10/11): * RRR|License - Not enough Remedy licenses? Save money by optimizing. * RRR|Log - Performance issues or elusive bugs? Analyze your Remedy logs. Find these products, and many free tools and utilities, at http://rrr.se. > 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" > _______________________________________________________________________________ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org attend wwrug12 www.wwrug12.com ARSList: "Where the Answers Are"
