jana
asked on
How to import SQL 2000 database to SQL 2014
What is the best method to import database from an old Microsoft SQL version 2000 to our SQL 2014
Perform a full backup of the existing database. Then create a new empty database on the new server and perform a Recovery with OVERWRITE on the new database using the old .bak file. I do this all the time.
ASKER
"Recovery"? or Restore?
ASKER
(If it's Restore we have done exactly that: we backup from sql0000, create that DB in swl2014 then restore with overwrite and still same problem)
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
ASKER
Oh!!! Now that one we didn't do, the SQL 2008 & compatibility stuff!! Ok, let's give it a try!!