How can we help you today? How can we help you today?
JonathanWatts
Activity overview Badges (0) Posts (12) Comments (294)

Comments

Sort by recent activity
Rhudson, We are looking into this issue at the moment, and hopefully will include it in a point release in the near future. Regards, Jonathan / comments
  1. Community
  2. SQL Compare Previous Versions
  3. "Hind" Hypothetical Indexes Appear as Clustered
Rhudson, We are looking into this issue at the moment, and hopefully will include it in a point release in the near future. Regards, Jonathan
0 votes
Good news then, this is being "considered" for the next version of SQL Refactor. As it is a fairly popular request it has a good chance of making it, as long as it is technically possible to do this inside of SSMS. Regards, Jonathan / comments
  1. Community
  2. SQL Compare Previous Versions
  3. Can I do this?
Good news then, this is being "considered" for the next version of SQL Refactor. As it is a fairly popular request it has a good chance of making it, as long as it is technically possible to do t...
0 votes
Hi there, Sorry about the delay. We will consider this for a future version of the product, but I cannot really say when this would be done. We are more likely to put a batch layout into SQL Refactor so that you can refactor your entire database in one shot and then use SQL Compare to synchronise this back to source control rather than combine SQL Refactor and SQL Compare. How does that sound? Regards, Jonathan / comments
  1. Community
  2. SQL Compare Previous Versions
  3. Can I do this?
Hi there, Sorry about the delay. We will consider this for a future version of the product, but I cannot really say when this would be done. We are more likely to put a batch layout into SQL Refac...
0 votes
Hi Gary, Sorry to hear that you experiences with SQL Compare 5 haven't been as one would have hoped. I will try to address your points as best I can, but can I ask which version of SQL Compare you were using before v5? 1) If you cannot see a different then it probably is in a line ending, can you check that your line endings are identical. This issue (66330) is marked down for addressing in a future version of SQL Compare. 2) There is an Ignore "SET QUOTED_IDENITIFER and SET ANSI NULLS" option in the Project Configuration > Options > More Options dialog which should give you what you need here. 3) I completely agree with you that this is a bug (68764) and a very idiotic one at that :oops:. We will be addressing it in future versions of the product. Hopefully, the first point release. 4) Because SQL Compare used the object definitions straight from the SQL Server system catalogs then I think that we would always consider this a difference the names are different therefore the object is different. 5) The problem you are seeing is because of the two ways that SQL Compare compares objects. At the start of the comparison, or each time you refresh, the engine does a semantic comparison of all the objects in the data sources and stores these results in the top grid. However, each time you select an object in the top grid the SQL Differences pane does a simple textual comparison of objects. This is done to improve performance and memory usage, and because 90% of textual differences are actually semantic differences too. However, in some cases like the one you highlight, a textual difference isn't actually a semantic difference as extra brackets don't change the result of the default. But the SQL Differences pane will highlight the textual differences although the top grid reports the object as identical. As we display most of these objects exactly as they are stored in the system catalogs we don't feel that we should alter them, and some of these differences may actually be of interest to users. The extra brackets that SQL Server 2005 adds shouldn't cause the top grid to be report a difference if that is the only difference in the object. This behaviour does cause a fair amount of confusion when looking at results so we are going to have to look into improving the SQL Differences pane difference matching in future releases, but this won't be changed in the initial point release of version 6. 6) There is also an ignore "Identity seed and increment values" in the same location as the option in (2) that should help. 7) This will be hopefully addressed in SQL Compare 6.1 If you have any further queries, you can contact me in this tread or via email (below). Regards, Jonathan : / comments
  1. Community
  2. SQL Compare Previous Versions
  3. Filters for SQL Compare ?
Hi Gary, Sorry to hear that you experiences with SQL Compare 5 haven't been as one would have hoped. I will try to address your points as best I can, but can I ask which version of SQL Compare you...
0 votes
Hi there, The final release will be out shortly, before the end of the month, we are just polishing off a few bits and pieces and testing the installer. Check for Update messages will be deployed with the final release so you should be able to upgrade from SQL Compare 5 that way. Regards, Jonathan / comments
  1. Community
  2. SQL Compare 6 Beta
  3. My Beta eval has expired - so where are the links to release
Hi there, The final release will be out shortly, before the end of the month, we are just polishing off a few bits and pieces and testing the installer. Check for Update messages will be deployed w...
0 votes
Paul, No there isn't anything wrong, SQL Compare does not support synchronising the status of triggers at the current time. We probably should address this, I will add a request to the system for future versions of SQL Compare to support this. Regards, Jonathan / comments
  1. Community
  2. SQL Compare Previous Versions
  3. Disabled Triggers not synchronizing properly
Paul, No there isn't anything wrong, SQL Compare does not support synchronising the status of triggers at the current time. We probably should address this, I will add a request to the system for ...
0 votes
We are looking into a sort issue at the moment, it doesn't appear to be sorting correctly on server.database name so we hope to have that fixed shortly. Explicit saving of projects prior to synchronisation is being lined up for the SQL Compare 6.1 release. Regards, Jonathan / comments
  1. Community
  2. SQL Compare 6 Beta
  3. Two Requests - Save Button & Sort Order on Compare Projects
We are looking into a sort issue at the moment, it doesn't appear to be sorting correctly on server.database name so we hope to have that fixed shortly. Explicit saving of projects prior to synchro...
0 votes
Hi Mike, I have tried doing what you describe, but cannot produce a situation where SQL Compare does not read the logins of copied correctly. Were these windows or SQL users? Did you have the save password checkbox unchecked when you copied the project? Regards, Jonathan / comments
  1. Community
  2. SQL Compare 6 Beta
  3. Changing Both Servers On A Comparison Project
Hi Mike, I have tried doing what you describe, but cannot produce a situation where SQL Compare does not read the logins of copied correctly. Were these windows or SQL users? Did you have the save...
0 votes
Mike, I have emailed you regarding this issue. Thanks, Jonathan / comments
  1. Community
  2. SQL Compare 6 Beta
  3. Application Failure When Synchronizing To Remove Schemas
Mike, I have emailed you regarding this issue. Thanks, Jonathan
0 votes
Mike, We found a race condition in SQL Compare which could be causing this hanging. We think we have now fixed this, so this should no longer occur when the final release comes out. Regards, Jonathan / comments
  1. Community
  2. SQL Compare 6 Beta
  3. Application Lockup When Serially Editing Many Projects
Mike, We found a race condition in SQL Compare which could be causing this hanging. We think we have now fixed this, so this should no longer occur when the final release comes out. Regards, Jonathan
0 votes
Total activity
518
Last activity
Member since
Following
0 users
Followed by
0 users
Votes
0
Subscriptions
212