Comments
Sort by recent activity
Unfortunately there are no plans to implement a 1 to many database comparison in SQL Compare. However, you can perform something like a 1 to many compare using the SQL Compare Command Line Interface (CLI). You are still comparing a pair of databases at any one time but you can construct a .bat file that lists all the comparison you wish to perform.
For example DatabaseA is the database you want as the 1 and Databases B to D are the many part of your scenario.
Your .bat file may look similar to this:
sqlcompare server1:server_1 /server2:server_2 /database1:databaseA /database2:databaseB /sync
sqlcompare server1:server_1 /server2:server_3 /database1:databaseA /database2:databaseC /sync
sqlcompare server1:server_1 /server2:server_4 /database1:databaseA /database2:databaseD /sync
Although you are still comparing a pair of databases at a time, the .bat file will loop through all the steps and you can perform a 1 to many compare. Further advice regarding the use of the CLI, can be found in the SQL Compare help file ->The command line interface section. Use this link to obtain the help file: http://www.red-gate.com/supportcenter/C ... c41845.htm / comments
Unfortunately there are no plans to implement a 1 to many database comparison in SQL Compare. However, you can perform something like a 1 to many compare using the SQL Compare Command Line Interfac...
Unfortunately, currently there isn't a way to tell SQL Prompt to use tabs instead of spaces for laying out the code. However, if you do want to convert them after laying out the code you can try the following:
- Highlight the section of code
- In Management Studio go to 'Edit' > 'Advanced' > 'Tabify selected lines'
This should change the tabs from spaces to actual tabs. The developers are currently working on SQL Prompt 4 at the moment and as I understand it there will be an option to keep tabs in the formatting options. SQL Prompt beta will be released Q2 2009. / comments
Unfortunately, currently there isn't a way to tell SQL Prompt to use tabs instead of spaces for laying out the code. However, if you do want to convert them after laying out the code you can try th...
Thanks for your feedback. This is a known issue and one that I don't think has an easy, simple solution. However, I've raised this as a feature request so that the developers will look into to see whether there's anyway of keeping the bookmarks after a code layout. For your reference the feature request tracking code is: SP-1580 / comments
Thanks for your feedback. This is a known issue and one that I don't think has an easy, simple solution. However, I've raised this as a feature request so that the developers will look into to see ...
The first thing to check would be to try to find out which other process has a lock on the options file. You could download Process Explorer from Microsoft - http://technet.microsoft.com/en-us/sysi ... 96653.aspx.
Once installed, run it and go 'Find' > 'Find handle or dll..', type in 'RedGateRefactorOptionSetDefaults' and then 'Search'. Does it show any processes with a handle on the file?
Regarding the EngineOptions.xml file; there's no reason why you can't copy the file over as long as you have the same versions installed on both your workstation and server. As always, I'd save a copy of the server options before you copy over the workstation options. / comments
The first thing to check would be to try to find out which other process has a lock on the options file. You could download Process Explorer from Microsoft - http://technet.microsoft.com/en-us/sysi...
Thanks for your feedback. I've added these to our feature request tracking database and they will be considered as future enhancements. / comments
Thanks for your feedback. I've added these to our feature request tracking database and they will be considered as future enhancements.
Could you explain exactly where you're writing your SQL code in Visual Studio 2008? If I click the 'New Query' button it opens a new Query window (with the Diagram, Results, SQL and Criteria panes). SQL Prompt isn't supported in this view so it shouldn't be enabled at all when coding. If you're writing your SQL in a .sql file then this is where SQL Prompt should be offering you the correct suggestions for the database that you've connected to. When you go to the SQL Prompt menu is 'Connect to Server..' highlighted? Could you try connecting to the server or if it is already connected try changing the connection to see if this makes any difference? / comments
Could you explain exactly where you're writing your SQL code in Visual Studio 2008? If I click the 'New Query' button it opens a new Query window (with the Diagram, Results, SQL and Criteria panes)...
Thanks for the feedback. Currently you'll have to clear the previous alert before you'll get an email notifying you of the next time the issue occurs. This was decided upon so that users aren't spammed if there is the same issue occurring frequently.
Obviously there are circumstances where it would be a lot better to have a more granular control over this frequency of emails. So I have raised this as a feature request and the developers will look into this when working on the next version. For your reference the feature request tracking code is: SSR-1377 / comments
Thanks for the feedback. Currently you'll have to clear the previous alert before you'll get an email notifying you of the next time the issue occurs. This was decided upon so that users aren't spa...
That's a tricky question as there isn't really a correct amount of spaces for a tab stop. It all depends on the editor that you're using and the platform that you're on. Generally the most common are 4, 5 and 8 (UNIX standard). / comments
That's a tricky question as there isn't really a correct amount of spaces for a tab stop. It all depends on the editor that you're using and the platform that you're on. Generally the most common a...
Unfortunately, it isn't possible to export scripts to an existing folder. This is by design and was set to prevent inconsistencies creeping in and causing issues when running the comparison. Apart from your method, presently the only work around is to run a comparison between the database and scripts folder and 'synch' to the folder.
We're considering adding the option to wipe the contents of an existing folder, if chosen, when exporting scripts. Would this be something that you'd be interested in seeing? / comments
Unfortunately, it isn't possible to export scripts to an existing folder. This is by design and was set to prevent inconsistencies creeping in and causing issues when running the comparison. Apart ...
Have you made sure that you've enabled system object prompting in the options? Go to SQL Prompt Options > Listed Candidates > Candidate Types and Filters, and check Show: System objects / comments
Have you made sure that you've enabled system object prompting in the options? Go to SQL Prompt Options > Listed Candidates > Candidate Types and Filters, and check Show: System objects