I have a large software application using a SQL 2008R2 DB. I also have a parallel installation of the software (the next version up) as well as a parallel copy of the DB. The schema for the two databases are nearly identical, but there are some tables with slight differences, additional columns etc. What I need to do is attempt to copy as much data to the new DB as possible and I can manually go through later and query the remaining pieces as needed.
On the new DB, II need to be able to:
-Drop all Constraints
-Allow ID Insert
-Import all data from each table into the new table where tables are identical, and skip data where certain fields do not exist in one or the other table.
-Recreate all Constraints after import.
I have tried using SSMS Import / Export functions all day, and cannot even get the Old DB to export without errors to any* format. (I have tried SQL to SQL, SQL to Excel, Access, Flat File....nothing works. There are about 200 tables in the DB, so Im trying to avoid going table by table.
Does anyone have suggestions?
Thanks in advance!