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?
Sheldon LivingstonConsultantAsked:
Who is Participating?
 
QlemoBatchelor, Developer and EE Topic AdvisorCommented:
Express does not come with Management Studio, you need to download one if you haven't already one installed. See my prior comment.
0
 
QlemoBatchelor, Developer and EE Topic AdvisorCommented:
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.
0
 
QlemoBatchelor, Developer and EE Topic AdvisorCommented:
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.
0
Introducing Cloud Class® training courses

Tech changes fast. You can learn faster. That’s why we’re bringing professional training courses to Experts Exchange. With a subscription, you can access all the Cloud Class® courses to expand your education, prep for certifications, and get top-notch instructions.

 
Sheldon LivingstonConsultantAuthor Commented:
How do you bring up the Interface?
0
 
Shaun VermaakTechnical Specialist/DeveloperCommented:
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
0
 
QlemoBatchelor, Developer and EE Topic AdvisorCommented:
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).
0
 
Sheldon LivingstonConsultantAuthor Commented:
Does anyone know how to open 2008 express so I can attempt to restore?
0
 
Vitor MontalvãoMSSQL Senior EngineerCommented:
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

0
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

All Courses

From novice to tech pro — start learning today.