Friday, March 23, 2012

How migrate SQL server 2000 database to SQL Server 2005 Express

I have a SQL server 2000 database.I have to migrate it to SQL Server 2005 Express.But I don't know how to do.

Is any one can help me ?

Thanks

You can detach the database using sp_detach_db and then re-attach it toyour SSE instance using sp_attach_db. This should workseamlessly, butback up first, just in case.

No comments:

Post a Comment