Migrate MSSQL 2005 Express -> MSSQL 2005 Srv

Hi!

What is the best way to migrate MSSQL 2005 Express -> MSSQL 2005 Srv?

YOu can either do an inplace update of your database (running the setup) or do a complete new install with prior backing up the database and restoring them afterwards.

HTH, Jens Suessmeyer.

http://www.sqlserver2005.de
|||

I was thinking more of the database it self.
Let's say I have developed an .NET site localy with a SQL Express-db, and later I want to upload it to my webhost and convert my express db to an "real" MS SQL server db that my webhost has supplied me with.

|||

Hi, thats no problem, either to a backup and restore or do a detauch and attach. The B/R solution would be the preferable on e for me.

HTH, Jens Suessmeyer.

http://www.sqlserver2005.de