1. Can SQL Delta do a Data Compare only?
No. Before performing a data comparison SQL Delta needs to load the schema (structure) of every database and then, needs to compare each table to see if the columns (fields) match.
SQL Delta will not proceed with data comparison of tables if there are important differences or a unique key cannot be found or ultimately user generated.
Given the usual time required to perform a schema compare and the embedded nature of schema and data comparison displays we determined that a schema load and compare will be required every time.
2. Can SQL Delta perform a data compare of a View?
No. Data comparison of views is not available since some views cannot be updated.
3. Can I share a project file?
Yes. However, SQL Delta is not particularly designed for sharing project files thus; one user's change can overwrite other users’ changes.
To share, use Windows Explorer to move the file to your shared location and with the project manager screen, click on the New menu to show Load New Project from file. Follow the prompts to load the project from your shared location.
4.What does the (Star) mean in the Project Manager?
The star indicates that the project has been modified (or is new) and has not been saved yet. Since projects are saved automatically when they are valid the project must be corrected in order to be valid.
Undo will restore the project to the disk version enabling the project to be valid once again.
5. My structure compare results displays a large number of differences that are minor differences, can I fix this?
You may prevent SQL Delta from comparing numerous minor elements of an object, which cause differences between two databases.
In project manager, open the project options to review the table compare and compare options.
6. Can I save my changes script instead of executing the change script?
Yes. In the structure view, click the Sync button and then click Save.
7. Is it possible to generate script to put data into tables?
Yes. SQL Delta allows users to save a data script after a data comparison is done.
To save a script that will create the initial insert script:
- Create a new database
- Perform a structure comparison and sync
- After a data comparison from the script manager, save the insert script
8. Are there plans to release a MySQL version in the future?
Yes. We hope to offer support for MySQL sometime in the future.