You are here: Skip Navigation LinksHome / Support / Frequently Asked Questions

SQL Examiner Frequently Asked Questions

  1. Can I setup SQL Examiner so it runs completely automatically?
  2. What versions of SQL Server does it support? Does it work with SQL Server 2008?
  3. Is the code that synchronizes databases safe enough and can I be sure that I will not lose data during the synchronization process?
  4. SQL Examiner detects that two tables are different after the database comparison and offers me to synchronize them though I changed only the order of columns. How can I avoid it?
  5. I select one stored procedure for synchronization, but there appear commands for changing several tables and stored procedures in the synchronization script. Why?
  6. There are two stored procedures in the compared databases and I added comments to one of them, but SQL Examiner marked this pair of procedures as identical. Why?
  7. In one of the compared databases all objects are created by the user named dbo and in the other database they are created by another user. Is it possible to make SQL Examiner recognize dbo.Table1 and user1.Table1 as one and the same object?
  8. Can I compare databases without taking indexes and constraints into account so that SQL Examiner does not offer me to synchronize tables with the same set of columns as different after the comparison?
  9. I synchronized users in two databases, but the added users cannot use their old passwords to access the modified database. Why?
  10. It is far from always that you can synchronize tables automatically. For example, it is impossible if you need to add a column with NULL insertions prohibited to a table. How can SQL Examiner help me in this case?
  11. And what if there are no records in the table a column that does not allow NULL values is added to? Why should I waste time on the problem that does not exist?
  12. And what if I rename a column in one of the compared tables? Will SQL Examiner be able to detect that it is the operation of renaming (and not removing the column from one database and adding it to the other one)?
  13. Where is it better to execute the synchronization script: in Query Analyzer or in SQL Examiner?
  14. Can I compare data with SQL Examiner?
  15. What will happen if there is an error during the database synchronization process?
  16. How can I exclude unnecessary objects from the comparison?

SQL Data Examiner Frequently Asked Questions

  1. Can I setup SQL Data Examiner so it runs completely automatically?
  2. What versions of SQL Server does it support? Does it work with SQL Server 2008?
  3. Why should I use SQL Data Examiner when there is DTS, the Import/Export Wizard?
  4. I want to transfer data from two tables related by a foreign key into another table. However, during the synchronization process the program displays an error. How can I avoid this?
  5. I was transferring data to a remote server for a long time, but then a system failure occurred and the changes were rolled back. How can I avoid this problem in the future?
  6. I have one database and want to create a script to insert data into its tables. Is it possible?
  7. There are 12 columns in a table. I want to compare and update only two of them. How can I do this with SQL Data Examiner?
  8. Can I specify a different primary key to compare tables?
  9. I want to synchronize two databases; each one contains more than 100 tables, but on the second step of the comparison SQL Data Examiner displays only 90 tables. Why does this happen?
  10. How does the SQL Data Examiner select a key column in the process of comparison, and why it is not specified for some of the tables?