Search
-
Re: How to handle field name changes
Thank you for your post into the forum. If a table column has been renamed. SQL Compare will synchronize the table by issuing two ALTER TABLE statements. The first ALTER TABLE statement will add new column with the old name. The second ALTER TABLE statement will drop the column with the new name. For example: Create a… -
Re: Smart Rename Issues
run this scenario to see the UPDATE( ) issue and the inserted/deleted column name issue (i'll post code to prove other two issues soon): CREATE TABLE t (RowID INT NOT NULL IDENTITY(1, 1) PRIMARY KEY, fooID INT, fooBAR VARCHAR(50), fooTLOOSE float) go CREATE TABLE t_Hist (HistID INT NOT NULL IDENTITY(1, 1) PRIMARY KEY,… -
Can't /exclude:table
I'm having a pretty straightforward problem. I can't exclude tables using the command line tool. I can exclude stored procedures though. Here is my command: SQLCompare.exe /database1:mydb1 /database2:mydb2/scriptfile:"C:\out.sql" /exclude:table:mytbl Buried in c:\out.sql is DDL I would expect if the table were not… -
Comparer ver. 6.2.0.271
Hello, please help me to exclud logins, users from comparasion results. The resulted script is like this: /*Script created by SQL Compare version 6.2.1 from Red Gate Software Ltd at 03.06.2011 08:58:22Run this script on (local).RESUM_GScript to make it the same as (local).RESUMPlease back up your database before running… -
error synchronizing db with full-text index to an empty db
Discussion by Brian Donahue · · Home› Discontinued and Previous Versions› SQL Compare Previous VersionsHi Tom, Thanks for writing. We've had a similar problem reported last week from another user. The scripting engine doesn't seem to check to see if stored procedures depend on full-text indexes before they script the changes to the destination database. Hopefully this can be fixed soon, now that we have an example to work… -
Re: sql 2008 filtered indexes not detected in sql compare 8
Please accept my apologies Jason for the delay in repying back to you. I still cannot reproduce this error. Using your example:CREATE TABLE Test ( ColA int NOT NULL, ColB int NOT NULL, IsObsolete bit NOT NULL ) ; CREATE UNIQUE NONCLUSTERED INDEX ixTest_ColAColB_UN ON Test (ColA, ColB) WHERE ColB IS NOT NULL AND IsObsolete… -
HowTo disable transactions in migration script?
Discussion by pil0t · · Home› Discontinued and Previous Versions› SQL Comparison SDK Previous VersionsHow to disable writing of this lines using ExecutionBlock.GetString(): @TRANCOUNT>0 ROLLBACK TRANSACTION @TRANCOUNT=0 BEGIN INSERT INTO #tmpErrors (Error) SELECT 1 BEGIN TRANSACTION END In SqlCompare I check "Do not use transactions in synchronisation scripts" in SDK there no such Options. Tried NoSQLPlumbing, but it… -
sql compare script statements not properly ordered
I've changed table structure adding some fields and added some stored procedures using those fields. SQL compare genereted script includes statements for new stored procedures first and next for tables what ends with errors during execute. Is that behavior by design? Here is example: /* Run this script on:… -
Re: Setting for transaction isolation level not used in script
I'm using the GUI only. I set the option under Tools, Application options to 'READ COMMITTED' and then create a new project, compare to databases, generate a script and the script then starts by setting the transaction isolation level to SERIALIZABLE. BTW, I'm using SQL Compare Pro version 10.4.8.87. Example output:/*Run… -
syntax error in the SQL script
Discussion by LexDeveloper · · Home› Discontinued and Previous Versions› SQL Compare Previous VersionsThe SQL script generated by SQL Compare 5 version 5.2.0.32 contained a syntax error that caused the sync to fail. The unlicensed trial version generated this block with an extra ']': PRINT N'Dropping constraints from [dbo].[field_reporter_text]'GOALTER TABLE [dbo].[field_reporter_text] DROP CONSTRAINT…
60 results