Do not use transactions but use bulk insert in order to reduce the get latest time. A 'flush and refill' approach using bulk insert should be faster in hours with 10K plus records.

A two processor, dual core computer with 8GB of RAM and a Windows experience index of 6.5 takes over 8 hours to get lates on 50K records.

I accidentally tripped over the right click menu that allows you to edit filter rules after trying earlier in the day to find it and giving up. Suggest adding a button to the UI so it is more obvious.

I am suprised there is no SQL CE product considering the knowledge and skillset at this company. I think your prices are a little steep but I would pay a premium for a SQL CE Product providing it did the obvious. Just a suggestion and opinion. Nice existing products though.

In our development model we set up a branch for each release of our product in our SCM tool.

So we need to frequently change the linkage for a DB to the new branch in source control after each release.

The tool currently doesn't have any edit capability on the linkage, so we are forced to remove and re-add it each time. This is somewhat awkward. Can we get an edit database link feature on the setup tab?

Whe you have a multi branched dababase environment could be helpful to export from the main database the list of tables linked (in xml ie, or json, as you wish), in order to reload it on the branch database. Obviously only for the objects that exist. An alternative could be to save to "other similar database" too..

Support multiple SYNONYM definitions depending on which server (dev, test, prod) the source is being extracted to.

Does SQL Connect work with a database project (.dbproj)?

Would be nice to have the option to include the drop statement inside of each object script. The option would be global over all scripts.

`EX: IF (OBJECT_ID('MyTable') IS NOT NULL) DROP TABLE MyTable`

I often have to put together a changelist that essentially lists the affected objects (tables, SPs, etc.) for documentation purposes. In Tortoise, I can highlight one or more revisions then in a separate page, shift or control select several or all items and hit Control-C to copy that as text. Then I can paste it and get a nice long list of table names, SP names etc like this:

SomeTable
AnotherTabl
usp_myStoredProc
usp_SomeoneElsesSP

It's something I use for documentation and it just would make life so much easier. Not sure if it's a big deal to make that happen.

In SVN log you can select multiple revisions and the changes list will display changes "files" across all of the revisions. Would like to see this feature in SQL Source Control history.

Sql compare allows the bottom file comparison pane to open as a new window. This allows you to see the list of different objects in one window and the file differences in another window. This is a great feature for comparing files and should be included with scc as it is in sql compare.

if computed column contains a 'hashbytes' function call, the hashbytes will be surrounded by [], like [hashbytes] which causes an error. this bug exists since version 1.1. why did fix that!

Most of our enterprise applications have mutiple instances of the same DB schema. We use the shared model and would like to update al instances once we commit changes on one of them. As a workaround we commit the changes and then hit revert changes on the instances we need to update

Commit dependencies dialogue shows blue dot on objects even when those objects have no changes to commit. This seems incorrect.

If there is a new Filter available at the moment this gets listed in the Get Latest tab with all other objects. Really you should apply this first before committing changes or getting latest. If you don’t there’s a danger you commit or get objects that should be excluded by the filter.
For example if a new filter excludes Users and Roles, but you fail to synch this before committing latest you can easily commit recently created users and roles that should simply have been excluded.

I want to store my day to day DBA type stuff in version control just to have access from other machines.

Team Foundation Server Proxy Server is excellent for saving time and bandwidth when connecting to TFS over a WAN link.

SQL Source Control doesn't seem to support this functionality at present

Please can we have migrations functionality for Perforce SCM