How to move database

Published 13 years ago

Hi there

We are using RemoteDesktopManager currently with a SQL Server 2008. How can we change the database to SQL Server 2012?

Best regards
Gabi

All Comments (3)

David Hervieux

Published 13 years ago

Hi,
It's very simple to migrate:
1. backup of the original database in SQL Server 2008
2. Create a new empty database with the same name in SQL Server 2012
3. Restore the database on the empty database
4. Change your RDM data source configuration to connect to the new database

David Hervieux

gabi

Published 13 years ago

Hi David
Ok thanks for the information. Sounds really simple :-)
Best regards
Gabi

David Hervieux

Published 13 years ago

No problem.

Quick note: it's possible that you might have to check an option to overwrite the database. This is mandatory when the backup origin is not from the same database.

David Hervieux