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.
It's really easier to just do a backup and restore with SQL Server Management Studio.