Link to home
Start Free TrialLog in
Avatar of jana
janaFlag for United States of America

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
Avatar of Russ Suter
Russ Suter

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.
Avatar of jana

ASKER

"Recovery"?  or Restore?
Avatar of jana

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
Avatar of Nakul Vachhrajani
Nakul Vachhrajani
Flag of India image

Link to home
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
Start Free Trial
Avatar of jana

ASKER

Oh!!! Now that one we didn't do, the SQL 2008 & compatibility stuff!!   Ok, let's give it a try!!