Developer Forum

Sofar I have used SQL 2000 developer edition. So I was pretty happy that MS
jumped on the freeware train and gave us SQL 2005 Express Server.

I was pretty convinced that it would be easy to restore a new SQL 2005
Express DB with an existing SQL 2000 DB file.
Unfortunately I was not able to do this. So you can imagine I was pretty
disapointed.

So my Question is, did I overlook something, and the Restoring is still
afterall possible, or is it really impossible to restore a SQL 2005 Express
DB with an existing SQL 2000 DB file, which in my opionion would be a big MS
fault.
Backward compatibility?

Thanks for the Help
Marcel

HI Marcel,

You can restore a SQL Server 2000 database onto SQL Server 2005
Express. One process you can follow is:

1) Use Enterprise Manager (or Query Analyzer) on SQL Server 2000 take a
full database backup of the database you want to restore

2) Open up SQL Server Management Studio Express and connect to the SQL
Server 2005 Express Edition instance

3) Create a new database with the same name as your SQL Server 2000
database

4) Using SQL Server Management Studio Express, restore your backup file
from SQL Server 2000 to the database you created in (3)

NOTE: When you are restoring, the dialog window will have a tab called
"Options". On this tab you must select "Overwrite the existing
database"

5) Your SQL Server 2000 database will be restored on the SQL Server
2005 Express Edition instance

Hope that helps a bit

Thanks for the answer

There is one more Problem which I guess I forgot to mension
The SQL Server 2005 Express is on a different maschine which as no
connection to the maschine with the SQL Server 2000

What shall I do?. Is it still possible to restore the DB.

Thanks for the help
Marcel

< XXXX@XXXXX.COM > schrieb im Newsbeitrag

Hi Marcel,

How big is your SQL Server 2000 database?

Your options in this case are to still take a backup of the SQL Server
2000 database (as I said in my previous post) and put it on something
like:

* CD
* DVD
* USB Flash Drive
* USB External Hard Disk

You can then use one of the above mediums (media?) to transfer your
backup to the machine with SQL Server 2005 Express Edition. After
transferring the backup, you can continue with the steps I have
described in my previous post.

Hope that helps.