MS SQL Server 2005 to MS SQL Server 2008

Hi,

I’m planning to migrate from sql 2005 to sql 2008.

  • backup database from MS NAV (sql 2005), then create new database from MS NAV (sql 2008) and restore the backup database from MS NAV (sql 2005)?

  • how can i restore all the users?

thanks in advance.

check this

http://support.microsoft.com/kb/918992

Hi,

thanks for the quick reply.

how about the migration of database;

  • backup database from MS NAV (sql 2005), then create new database from MS NAV (sql 2008) and restore the backup database from MS NAV (sql 2005)?

is this the correct way to migrate database?

thank you.

There are so many ways to upgrade…

what you have mentioned is on of them…

you can google to get more help…

http://msdn.microsoft.com/en-us/library/ms144267.aspx

http://www.packtpub.com/article/moving-a-database-from-sql-server-2005-to-sql-server-2008-in-three-steps

Dont forget to test the performance after upgrading.