Migrate SQL Server

0 vote

avatar

Is there a way to migrate from one SQL server to an other?
My case. From SQL2005 to SQL2008.
I tried to setup a new Data Source to the new server. then Export from the old server all sessions.
The problem is that it doesn't export users and security groups.
The other problem is that I don't know how to export connections log.
Thank you.

Enrique Noceda
Spain

All Comments (1)

avatar

Hi,
It's really easier to just do a backup and restore with SQL Server Management Studio.

David Hervieux