|
Q: Can i create a project?
A: Yes. A project contains your database update script files and the data migration plan. Very important information including your developement knowlege like information of default values for new columns are also stored in the project in XML files. You can save and load projects (as XML files) from the file menu.
Q: Will my data be kept intact?
A: Yes and only the minimum necessary modifications will be performed on your database. The rest will be left untouched. Q: The script that Sync For SQLServer generates doesn't work. Why not?
A: Although the scripts that Sync For SQLServer generates work in most situations they are just a baseline. It workes 99%. You sometimes have to work them out before running them. Test them carefully and backup your databases: this is strongly recommended. If you find a situation in which this process does not work, please let us know. Q: What happens if you have to create a new column in your table?
A: Sync For SQLServer checks if an ALTER TABLE is allowed. Otherwise the table will be recreated. It unloads the table data into a temporary table, it drops the table foreign keys, deletes the table and creates a new table with the new schema. Then it loads the data from the temporary table into the new table. If there are new columns where no temporary table data is available and the column definition does not allow NULL values, a default value is inserted in all rows for this column (or an SQL expression is evaluated and that value will be used).
Q: Can you help me? The change script generates a lot of errors.
A: Please try to correct the first error, the following errors will often dissapear. You have to check the error because there are cases where the script cannot work: e. g. your table will get a new Unique Key and the old table data does not fit. You will have to modify the data rows manually before running the script again. Q: Is there support for transactions?
A: Yes. In the options you can select to use transaction code for the change script. If something goes wrong no changes at all will be performed on your destination database. Q: Some data is missing in the difference report.
A: It sometimes occures on Vista. We search fo a solution. |
