The Database Mover tool helps you move databases from one SQL Server instance to another, preserving the associated data files and the SQL Server logins. With this tool, you can move or copy databases between SQL Server instances or on the same SQL Server instance. You can also relocate the data files for a database to a different storage device while keeping the database on the same SQL Server. For example, you can move a performance intensive database to a faster hard disk to speed up performance. You can also rename a database while moving or copying to another location.
The Database Mover tool requires your Windows user account to have administrative access to the target SQL Server instance because the tool uses administrative shares to perform the file copy. By default, the Database Mover tool connects to the specified SQL Server instance using the credentials of your currently logged on Windows account, and then collects information about the specified database.
To perform the move, the Database Mover tool detaches the source database to copy the data files for the specified database to the target SQL Server instance. The tool then attaches the database at the source and target instances, and copies the SQL Server logins to the target instance. The copy database and move data files operation leaves the source database intact. The move database operation drops or deletes the source database.
Idera Website | Products | Purchase | Support | Resources | Community | About Us | Legal |
---|