Posts
Sort by recent activity
Incorrect DBCC CHECKIDENT script
SQL Compare 8.2.0.16
The script being generated is:
DECLARE @idVal INT
SELECT @idVal = IDENT_CURRENT(N'Aplicacoes')
DBCC CHECKIDENT([tmp_rg_xx_Aplicacoes], RESEED, @idVal)
...
Mapping columns on table comparison
Is there a way to map columns in table comparisons?
Let's say that in database A I have column Stuff int in table T and in database B I have column BigStuff bigint.
I want o generate a script that ...
BUG: Synchronization script generates insert for all rows...
... when the schema in the source database is different from the schema on the destination database.
If my source table is dbo.MyTable and the destination table is MySchema.MyTable, the comparison ...
SUGGESTION: Order inserts on self referencing tables
If the project definition doesn't have disable foreign keys checked (probably because the user executing the script doesn't have permission), SQL Data Compare should order the inserts in order to h...
TypeForwardedToAttribute: Offer a link to the destination
.NET 4.0 has a few types with the TypeForwardedToAttribute applied.
It would be nice to have a link to the destionation type/member.
[Suggestion] Add "Open in .NET Reflector" to Visual Studio..
... when an assembly is selected in the Solution Explorer
Allow Windows Authentication with specified credentials
My company is implementing a policy where all connections to databases must be made using Windows Authentication.
On top of that, there are, at least, two domains (Production and Quality Assurance)...
Options/Proxy Server not working correctly
When working behind a proxy, "Use settings from Internet Explorer" doesn't work. I need to explicitly configure the proxy server.
Sugestion: Synchronization scripts w/o object manipulation
Sometimes I need to synchronize databases where I don't have permissions to create/drop anything. It would be nice to have synchorinzation scripts with just insert, delete or update statements.
Suggestion: Default values in the synchronization script
I have this set of databases that I must keep in "sync".
Each table has a DateTime column with the time of the last modification. These columns are excluded from the comparison but must be set in t...