248 results found
-
Add a "source option" for nuget package store
It can be very useful to add an option for reading from a nuget package store, in addition to "Direct From Source Control" and "Scripts folder".
The package should be reached unsing the http url. This is useful when reading from a build server outcome, which can upload the packages to the nuget store.33 votes -
Show/deploy static data changes in SQL Compare UI
Please add an option in the UI of SQL Compare to include static data. This would be equivalent to the command-line option "Include:StaticData"
If selected it would compare and deploy data changes to the target DB (along with the schema changes), and ideally it could also link the static data table in the target DB if not already linked. Use case is where a new table is created and linked in a dev branch and you want to deploy to trunk.
27 votes -
Ignore database variables used in Visual Studio Project
There are cases when for continuous intergration we use Visual Studio Project 2013 to build our databses. Sometimes we need to use database variables these look like: [$(DatabaseName)]. Though Visual Studio can recognize it as a variable, redgate will not and will output that as it is for deployment or comparison.There need to be an option where these variables can be ignored or output using the variable name which is specified in the project.
10 votes -
option to ignore case in schema name compare
In version 11.1.30.30, I have 2 database where objects only differ because on schema has names that are camel cased and the other is all lowercased; everything else is identical but keeps showing in list of 'objects tat exist in both but are different'
7 votes -
Make SQL Compare Three-part identifiers aware and filterable
Not always a deployed database has the same name of the source database due to customers' naming conventions. So it'd be great if SQL Compare will be three-part identifiers aware, so that if you compare the same table from different named databases as following:
SELECT *
FROM MyDatabaseA.MyTableSELECT *
FROM MyDatabaseB.MyTableSQL Compare will not show them as different if you want a three-part identifiers insensitive comparison.
15 votes -
Ability to Compare from a dacpac to a Database and generate sync scripts
I understand that you have the ability to compare DBs to sqlproj but it would be nice to have it compare with a dacpac. That way I can build a project, persist that build number and deploy from that dacpac.
6 votes -
Add option to stop processing if the database in the USE statement doesn't exist
If you run a script with option to use the "USE database" clause and the database doesn't exist the script will go ahead and attempt to run the script in the current database. This is usually "master" if you are in a new query window and if you only adding new items it will add them all to the master db.
5 votes -
Sync a Database to a Source Control Repository
We really need the ability to "sync" a database to VCS repository, not just compare. I know this limitation exists by design because conflicts can be missed, but we have a scenario that demands it. We have batch check-ins that can take up to a half a day to commit manually.
10 votes
- Don't see your idea?