How can we help you today? How can we help you today?
david connell
Activity overview Badges (0) Posts (6) Comments (128)

Comments

Sort by recent activity
Hi Mago, Thank you for your data... I think that the confusion has occurred with the <casesensitive /> This means that the regular expressions that are being used are case sensitive, not that the database/mappings are being treated as case sensitive. As the default options is not case sensitive if you specify the additional line <options>none</options> in your XML file this will then work correctly. You may wish to specify some of the options. However I would recomend that you set up a SQL Data Compare project and then use the project in the command line, because you will then be able to do cool things like map up some of your other tables with custom comparison keys. etc. Hope that helps. Best regards David / comments
  1. Community
  2. SQL Data Compare Previous Versions
  3. Error: A duplicate object name has been found
Hi Mago, Thank you for your data... I think that the confusion has occurred with the <casesensitive /> This means that the regular expressions that are being used are case sensitive, not that the d...
0 votes
Hi Mago, Please could you confirm if you can compare the databases with SQL Compare 5.X. (ie do you get "A duplicate object name has been found" error when running SQL Compare.) Thank you. regards David Connell / comments
  1. Community
  2. SQL Data Compare Previous Versions
  3. Error: A duplicate object name has been found
Hi Mago, Please could you confirm if you can compare the databases with SQL Compare 5.X. (ie do you get "A duplicate object name has been found" error when running SQL Compare.) Thank you. regards...
0 votes
Hi Paul, Thank you for your additional information. We wil investigate this issue here. This problem will be fixed in a future release. Regards David / comments
  1. Community
  2. SQL Compare Previous Versions
  3. Constraints and Indexes order
Hi Paul, Thank you for your additional information. We wil investigate this issue here. This problem will be fixed in a future release. Regards David
0 votes
Hi Lee, Thank you for your comments. Please note that in the case of two identical databases with indexes established in varying orders, the objects will be marked as identical. However the SQL Difference viewer will highlight the order difference. Best regards David / comments
  1. Community
  2. SQL Compare Previous Versions
  3. Constraints and Indexes order
Hi Lee, Thank you for your comments. Please note that in the case of two identical databases with indexes established in varying orders, the objects will be marked as identical. However the SQL Dif...
0 votes
Hi Lee, I understand that this will lead to false positives within the SQL Difference viewer, however it is the expected functionality. The alter tables are ordered before the create indexes and as a result the SQL is not correctly aligned. The SQL Differences panel will highlight the Create Index/Alter Table as a difference. Although it is not considered when determining the status for an object (Different, Identical, Only in db 1 or db 2). We will investigate in the future splitting up the SQL labelled as “Constraints and Indexes†into smaller more logical blocks, which could help in your situation. Best regards, David Connell / comments
  1. Community
  2. SQL Compare Previous Versions
  3. Constraints and Indexes order
Hi Lee, I understand that this will lead to false positives within the SQL Difference viewer, however it is the expected functionality. The alter tables are ordered before the create indexes and as...
0 votes
Hi Lee, Very sorry for the delay. I need to verify some information with a developer and I will get back this afternoon. Best Regards David Connell / comments
  1. Community
  2. SQL Compare Previous Versions
  3. Constraints and Indexes order
Hi Lee, Very sorry for the delay. I need to verify some information with a developer and I will get back this afternoon. Best Regards David Connell
0 votes
Hi there, Is it possible to send me a simple test case please. (david.connell@red-gate.com) Best regards David Connell / comments
  1. Community
  2. SQL Data Compare Previous Versions
  3. DC generates script with multiple drop/add FK constraints
Hi there, Is it possible to send me a simple test case please. (david.connell@red-gate.com) Best regards David Connell
0 votes
Hi Thomas, Can you backup the problematic database, zip it up and e-mail it to me at david.connell@red-gate.com please? That will help us troubleshoot the problem. -David / comments
  1. Community
  2. SQL Bundle 5 Beta
  3. SQL Packager: Foreign key constraint problem
Hi Thomas, Can you backup the problematic database, zip it up and e-mail it to me at david.connell@red-gate.com please? That will help us troubleshoot the problem. -David
0 votes
Hi there, I am sorry to say that caching of Server Intances did not make it into this release. I hope that we can get this feature into the next release. Thanks, David / comments
  1. Community
  2. SQL Bundle 5 Beta
  3. Discovering instances (or atleast cahcing them when entered)
Hi there, I am sorry to say that caching of Server Intances did not make it into this release. I hope that we can get this feature into the next release. Thanks, David
0 votes
Hi there, sorry for the delay, SQL Search 1.1.9 should fixe this problem, please tell me if it does not. David / comments
  1. Community
  2. SQL Search Previous Versions
  3. Doesn't work on Windows 8.1
Hi there, sorry for the delay, SQL Search 1.1.9 should fixe this problem, please tell me if it does not. David
0 votes
Total activity
212
Last activity
Member since
Following
0 users
Followed by
0 users
Votes
0
Subscriptions
78