01 - Is Universal Migrator for you?

01 - Is Universal Migrator for you?

The Universal Migrator is a suite of tools that assists IT consultants in mass-transferring data and performing whole-sale migrations between different systems.  It is a technical tool for technical individuals.

You should use Universal Migrator if:

  • You need to mass-transfer data between different systems
  • You can write a SQL query that uses SELECT / UPDATE / DELETE
  • (Bonus) You can write a SQL query that uses JOIN / PIVOT

 

You should not use Universal Migrator if:

  • You have a small amount of data you transfer
  • You are not comfortable working in SQL
  • You prefer working with CSV files

Have a customer who needs a migration?

If Universal Migrator is not for you but you have a customer who needs a migration, please contact us and we can pair you with another consultant who can perform the work in conjunction with your team.


Get Paid for Referrals

Most consultants we work with will pay a finders fee to other consultants who bring them projects.

    • Related Articles

    • 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. ...

    • 04 - Pricing Requirements

      While you may generally set your own pricing for migrations, there are some rules you must follow. Invoices and Scopes of Service Your invoices/Scopes of Service must always: List Universal Migrator as a non-optional, required item for the project. ...

    • 03.12 - Scoping Topics: How will security settings migrate?

      Security Settings should Not be Automatically Transferred Universal Migrator intentionally does not migrate security settings between systems. The following are a few reasons why Universal Migrator does not transfer security settings between systems. ...

    • 01 - Tweaking a Restore

      Sometimes after restoring a backup, a customer may want you to tweak the data that is in their new system. Tweaking data post-restore is easy! Let's say that the customer wants you to "mark as complete" all tasks that are related to archived (closed) ...

    • 03 - Working with Client-Provided CSV Data

      Sometimes firms will have a special CSVs that they may provide that will be used to tweak or adjust data in the backup. When you receive this data you should do the following: DO NOT import these CSVs directly into a Universal Migrator database. ...