587 results found
-
static data, Bulk insert for get latest
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.
10 votesThanks for this feedback and for the votes for this suggestion.
For users who need to manage larger volumes of static data, we currently recommend versioning the database with SQL Change Automation. SQL Change Automation has stronger support for static data:
- Supports column filtered static data tables in the SCA plugin in SSMS
- Supports multiple post-deployment scripts, in case there is a preference to manage static data tables in dedicated post-deployment scripts
- Allows approaches like bulk loading larger static data tables by supporting SQLCMD variables in migration and post-deployment scripts
I do understand that you are looking for this feature in SQL Source Control, but wanted to surface this option for other readers who may be interested in either tool.
-
New Product - SQL Server Compact Edition
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.
6 votes -
Add ability to edit database link
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?
9 votes -
Export the list of static data linked
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..
7 votes -
Support multiple Synonym definitions that change across environments
Support multiple SYNONYM definitions depending on which server (dev, test, prod) the source is being extracted to.
25 votes -
Does SQL Connect work with a database project (.dbproj)?
Does SQL Connect work with a database project (.dbproj)?
1 vote -
Drop statement in script
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 MyTable4 votes -
Add ability to generate a list of affected objects
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
uspmyStoredProc
uspSomeoneElsesSPIt'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…
10 votes -
Select multiple versions in History
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.
1 vote -
Open bottom pane in new window
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.
3 votes -
hashbyte
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!
3 votes -
Shared Model - multiple instances of the same DB
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
70 votes -
4 votes
-
Commit dependencies dialogue blue dot.
Commit dependencies dialogue shows blue dot on objects even when those objects have no changes to commit. This seems incorrect.
3 votes -
Make it clearer when there is a new Filter available
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.1 vote -
Add the ability to store queries in repository
I want to store my day to day DBA type stuff in version control just to have access from other machines.
1 vote -
Better importing of existing repositories
Thanks for the link!
I've done something similar to this before, but it takes a lot of time and you have to be very diligent. I'm not sure I'm going to go with this route, but just in case someone else is thinking about it, here is the general idea:
The idea is similar to the link above. You add your db to SQL Source Control (SSC), which creates a new repository/folder, then inspect the folder/file structure it created. You then take your preexisting repository and rename each file to match the same structure as the one created by SSC.…
2 votes -
Link databses using solution or project file
We have a lot of databases. It's very time consuming to link all databases one at a time for every developer. It should be possible to make use of a solution file to link a solution with all the databases, rather then mapping one by one.
25 votes -
Force "Get Latest" even when tool thinks there are no changes.
Our test environment is set up such that the servers and databases all have the same name as production. This causes SQL Source Control to think I'm connected to ServerA when I am really connected to ServerB. Thus, the "Get Latest" tab shows "No new changes in source control" even though there are changes I wish to get. The "Commit Changes" tab still shows changes so the tool knows there are differences, but won't show any "Get Latest" items. This happens in both the "Dedicated" and "Shared" setups. I must unlink the database and relink it in order for it…
20 votes -
SQL Doc History
Include an objects history in SQL Doc.
6 votes
- Don't see your idea?