As a database administrator, one of the tasks you may need to perform is upgrading SQL Server Instances from lower to higher versions. This can be a complex process, involving tasks such as mapping users to databases, replicating permissions, and migrating objects. While experienced DBAs are familiar with this process, what about those who are not full-time DBAs or small businesses that can’t afford to hire a database expert?

Introducing SQL Migrator, a free and simple-to-use tool that can assist IT professionals with limited SQL Server administration background in upgrading or migrating their environment. It can also be used by developers who want to periodically refresh their development environment without relying on a DBA.

SQL Migrator simplifies the upgrade process by providing a GUI-based interface that guides users through each step. It allows users to migrate all SQL Server objects or refresh user databases using existing backup files. While there are some limitations, such as only supporting full backups with the “With Recovery” option and placing data and log files in default folders, SQL Migrator offers a convenient alternative to using SSMS.

Here’s how to use SQL Migrator to refresh user databases:

1. Install the required Microsoft® SQL Server® 2016 Feature Pack files: SQLSysClrTypes.msi and SharedManagementObjects.msi.
2. Launch SQL Migrator and choose the “Refresh User Databases” option.
3. Verify the prerequisites and continue if they are met.
4. Enter the target SQL instance name and click Next.
5. Specify the folder that contains the native full backup files with the “.bak” extension. The logged-in account should have full control permission on the folder.
6. Click “Verify Access” to perform checks and move forward.
7. Click “Show Databases” to view the available backup files and select the databases to restore.
8. Choose whether to overwrite existing databases on the target or set the compatibility mode to the newer version.
9. Click “Migrate Databases” and relax as the selected databases are restored automatically and sequentially.

To review logs for activity performed or any errors, you can access the “SQL Migrator Log Folder” in the application’s start menu hive.

SQL Migrator is a valuable tool for simplifying the upgrade process for those who may not have extensive knowledge of database administration. It provides a user-friendly interface and automates many of the necessary steps. While it may not be suitable for all scenarios, it offers a convenient solution for small businesses and developers.

References and Acknowledgements:

We would like to thank Chrissy Lemaire, an MCC and MVP, for her inspiring PowerShell scripts that helped in the development of SQL Migrator. One of her scripts can be found on the Microsoft TechNet Site.