Link to home
Start Free TrialLog in
Avatar of Sheldon Livingston
Sheldon LivingstonFlag for United States of America

asked on

Upgrade SQL 2000 DB to SQL 2014

I see that I need to backup a SQL 2000 DB and restore it to SQL 2008.  Then backup the 2008 DB and restore it to 2014.

I installed SQL Server 2008 R2 express (SQLEXPR_x64_ENU.exe).

How do I open a 2008 interface so I can restore the DB?
Avatar of Qlemo
Qlemo
Flag of Germany image

You  need SQL Server 2008 to do that, not 2008 R2, because the metadata update procedures now have no code for 2000 anymore.
Correction: You should be able to restore the 2000 DB on 2008 R2 without issues.
You need to make sure certain Service Packs are installed in your instances. http://www.itprotoday.com/microsoft-sql-server/sql-select-steps-migrate-sql-server-2000-sql-server-2014 ist detailing the process.
Avatar of Sheldon Livingston

ASKER

How do you bring up the Interface?
I understand that you want to upgrade from MSSQL 2000 to MSSQL 2014 but did you run DMA to check if it is compatible?
https://www.microsoft.com/en-us/download/details.aspx?id=53595
As interface you can use the SSMS of 2014, or the new one (2017), whatever you have. You might have issues connecting to the 2000 with those, but the 2008 (R2) should work fine here.
Note that Express usually does not activate network access, only local (using shared memory).
Does anyone know how to open 2008 express so I can attempt to restore?
ASKER CERTIFIED SOLUTION
Avatar of Qlemo
Qlemo
Flag of Germany 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
If you only want to restore the database then you can use sqlcmd. Open a command prompt and positioning yourself in the same folder where sqlcmd.exe is and then run the following (where necessary replace with the real names from your system):
C:\>SQLCMD -E -S Servername\Express -Q "RESTORE DATABASE DatabaseNameHere FROM DISK='d:\backup\databasename.bak'"

Open in new window