Save time working with databases
Save time creating and comparing your SQL databases. And load data into your SQL database without errors. SQL DataTool is a database solution for database professional to perform specific specialized tasks with limited effort. Whether you want to compare your development database with your production database, or have trouble importing data into your database, SQL DataTool will help you with this.
Compare databases: Schemas, tables, procedures, views, ...
SQL DataTool gives you as database professional the ability to easily compare SQL databases. You can review differences between databases in tables and columns, users, procedures and views. You can now easily review whether your databases are in sync!
Sync databases using generated scripts
Migrate your databases to different environments using the generated scripts. Whether you want to deploy a new environment, upgrade an existing environment, or move your development environment to production, SQL DataTool helps you moving forward.
Easily import data... without errors
Have you ever had issues while importing data into a database? One record with an error breaks your data load, and the source table remains empty. SQL DataTool allows you to solve errors when importing data. Records with errors are written away in an error-file, without breaking the import. You can then solve these errors and append the data to the already imported table.
Saves you time - Every time
Do you have files that have to be loaded regularly? With SQL DataTool you can save your import settings, so you can reuse these settings. No need to find the right settings again, just store your imports.
| Other Tools / SQL Server Import wizard | SQL DataTool | |
|---|---|---|
| Import Access database |
✔
|
✔
|
| Import Excel files |
✔
|
✔
|
| Import plain text/csv files |
✔
|
✔
|
| Import multiple text files in one run |
✘
|
✔
|
| Interpretation of line breaks |
✘
|
✔
|
| Advanced date import |
✘
|
✔
|
| Import continues on error |
✘
|
✔
|
| Solution to erroneous records |
✘
|
✔
|
| Compare database schemas |
✘
|
✔
|
| Generate deploy scripts |
✘
|
✔
|
| Generate sync scripts |
✘
|
✔
|