04.01 - Creating a "Reverse" Backup
In nearly all situations, when you are using Universal Migrator to perform a backup, you should use Universal Migrator from the Migration Workstation and have it copy data from a snapshot of the database that is on the Migration Workstation.
Sometimes, however, there are rare circumstances where Universal Migrator may need to be run on the server itself and have the server push data to the migration workstation: we call this a "reverse" backup.
In order to create a reverse backup, you should do the following:
On the Migration Workstation:
- Open firewall port for MSSQL (port 1433) by following these instructions:
How to Open a Port in Windows Firewall
On the Server:
- Run Universal Migrator
- When it asks where the backup should be stored, adjust the following options:
- Authentication: Credential
- User Name: sa
- Password: <Your SA password for SQL Server on your migration workstation>
- Server Name: <The IP Address of your migration workstation>
Related Articles
02 - General Backup Guidelines
When backing up data, the process will vary from one application to another, however, there are some general guidelines that you should always follow: Always Backup All Data You Will Ever Need When you are creating a backup, always back up all the ...01 - Reviewing a Backup
The Universal Database contains tables for each type of data you might backup or restore between systems. While most of the columns are unique to each table, certain columns exist on all tables. The purpose of this article is to describe what each ...01 - Tweaking a Backup
After you have completed a backup, your client may want you to tweak the data before restoring it into their new system. The scripts for any tweaks that you apply should be saved into your Migration Playbook. This will allow you to replay all the ...02 - Creating a Migration Playbook
When a surgeon goes into an operating room, they have a written-down plan that describes exactly what they are going to do. This plan provides confidence and assurance that the project will be done correctly and ensures that no step can be lost or ...01 - Creating a Migration Workspace
Prior to scoping a migration, you should create a migration workspace for the prospective project on your migration workstation. This folder structure will contain notes and important information about the project that you will add to as you discuss ...