Comments
Sort by recent activity
You should be able to see the table or view definition by hovering over it. When you hover over one of these objects you should see a hint appear showing you which sort of object it is (if you don't see these hints then you may have to turn on hinting - SQL Prompt > Options > Behaviour > Information Panels > Enable Object Definition Hints). If you click on these hints that appear then it will bring up the object definition (schema) window.
If you resize this window then it should stay that size for the duration of the session that you're working in. / comments
You should be able to see the table or view definition by hovering over it. When you hover over one of these objects you should see a hint appear showing you which sort of object it is (if you don'...
I've passed this onto the development team. Hopefully this is something that they can improve on in the future and make SQL Prompt more intelligent in this area. For your reference the feature request tracking code is: SP-1606 / comments
I've passed this onto the development team. Hopefully this is something that they can improve on in the future and make SQL Prompt more intelligent in this area. For your reference the feature requ...
Does this seem to happen on all tables (system tables and user tables), or is it certain objects that it affects?
Do you have SQL Server Management Studio installed and, if so, does the tab key work as expected when using SSMS rather than VS2008? Has the tab key ever worked in VS2008 and if so were there any changes to VS just before it stopped working? Do you have any other third party add-ins installed?
If it works in SSMS and doesn't work with any tables at all, I'd be inclined to try a reinstall of SQL Prompt to see if this reinstates the key bindings. / comments
Does this seem to happen on all tables (system tables and user tables), or is it certain objects that it affects?
Do you have SQL Server Management Studio installed and, if so, does the tab key wor...
When SQL Data Compare compares the databases it does this without any lock on the tables (we even use WITH NOLOCK). However, when you run the synchronization the destination database will get locks on the specific tables while the transaction is run. This is controlled by SQL Server in the same way that if you just run your own updates\inserts\deletes on a table there will be locks while the data is changing. / comments
When SQL Data Compare compares the databases it does this without any lock on the tables (we even use WITH NOLOCK). However, when you run the synchronization the destination database will get locks...
Thanks for your feedback. I've raised this as a feature request in our issue tracking software. The product manager and developers will decide how important this feature is and whether it will be implemented in the future. This will depend on a number of considerations including how many users it would benefit.
For your reference the feature tracking code is: SP-1592 / comments
Thanks for your feedback. I've raised this as a feature request in our issue tracking software. The product manager and developers will decide how important this feature is and whether it will be i...
This is currently not possible in SQL Compare, so I've created a feature request for you. The developers will consider this when working on the next version of SQL Compare. For your reference the feature tracking code is: SC-4296 / comments
This is currently not possible in SQL Compare, so I've created a feature request for you. The developers will consider this when working on the next version of SQL Compare. For your reference the f...
SQL Compare, by default, will not parse different column order of tables as having a real difference i.e. they will be seen as identical objects in the top pane and the column order won't be changed when synchronizing. However, if you select the option to 'Force column order' they will be shown as different objects in the top pane of the results and this column order will be synchronized between the two tables.
The bottom pane (SQL Differences) is purely a textual comparison. It will show you the differences even if they aren't seen as real differences in the top pane. Would you like, in some way, to be able to rearrange and sort the text in the SQL Differences pane so that it matches up the columns and makes it easier to see the differences? / comments
SQL Compare, by default, will not parse different column order of tables as having a real difference i.e. they will be seen as identical objects in the top pane and the column order won't be change...
Thanks for the feedback. There have been a number of users ask if it would be possible to add their own alerts. This is something that we're considering for a future version of SQL Response. I've added your comments to the feature request. For your reference the feature request tracking code is: SSR-1188 / comments
Thanks for the feedback. There have been a number of users ask if it would be possible to add their own alerts. This is something that we're considering for a future version of SQL Response. I've a...
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...