Forum / Remote Desktop Manager - Feature Request

Migrate SQL Server

  • Create an Issue
  • Cancel

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

Clock7 yrs

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

David Hervieux

signaturesignature

Clock7 yrs