Database Assistant

This tool contains multiple features that help you analyze and refactor your existing database, migrate legacy databases and improve your current database. Once the analysis is complete, it can generate SQL Scripts that will fix the issues, if those issues are easily fixable. If it's not fixable, then it will let you know and you can decide how to fix those issues.

In addition to analyzing your database, the Database Assistant helps with combining two table schemas. This is useful when you are wanting to merge two tables together, or make a new table that is a composite of two other tables.

The complimentary tool is the Table Data Combiner tool that helps generate a script that will combine the data from two tables into another table.

Finally, the Table Schema Duplicator tool allows you to duplicate existing table schemas into a new table schemas in batches. Normally you would right click on a table, tell it to generate a create script, then you would then modify the script with the new table name, new identity column name, etc... This tool allows you to just select all the tables you want to create duplicates of, change the table names and column names and then it generates a script for you.