Page History

...

To move a database from one SQL Server instance to another:

1. Open the Idera IDERA SQL Admin Toolset Launchpad, and then click Database Mover.
2. On the Welcome window, click Next.
3. Select which action you want to perform, and then click Next.
4. If you are copying or moving a database, select the source and destination SQL Server instances and databases. To rename the database during the copy or move operation, specify a new name for the destination database. Click Next.
5. If you are moving data files, select the source SQL Server instance and database, and then click Next.
6. Specify the appropriate copy or move options, and then click Next.
7. Specify the target folder to which the data files should be copied or moved, and then click Next.
8. Select which SQL Server logins you want to copy or move to the target instance, and then click Next.
9. Review the summary, and then click Finish.

...

SQL Admin Toolset delivers 24 essential administration tools. Learn more > >

...