CODEWITHSUNDEEP
sqlsql-server-2005
Lasse Edsvik
Lasse Edsvik

Reputation: 9298

Sql 2000 database to Sql 2005 express db

I have a database that is on a SQL 2000 server, and I would like to make it a Sql 2005 express edition database.

What is needed to do in order to make that work?

/M

Upvotes: 1

Views: 64

Answers (1)

Cody C
Cody C

Reputation: 4797

The cleanest way would be to create a new database in SQL 2005 and import all the objects in.

You can also backup and restore into the SQL 2005 environment. That will work as well

Upvotes: 1

Related Questions