Activity overview
Latest activity by LexDeveloper
Nothing came back from select name from sysobjects where name like 'DF_field_reporter_text_frt_lang_code
frt_lang_%' AND xtype='F'
but that made me dig deeper into our database, and that is where the problem was. :oops:
When we generated the script for the destination table, we got
CREATE TABLE [*****].[field_reporter_text]
(
[frt_fr_text_id] [int] NOT NULL IDENTITY(1, 1),
[frc_category_id] [int] NULL,
[frt_form_text] [text] NOT NULL,
[frt_language] [varchar] (10) NULL,
[frt_lang_code] [int] NOT NULL CONSTRAINT [DF_field_reporter_text_frt_lang_code
frt_lang_code]] DEFAULT (17),
[frt_effective_date] [datetime] NOT NULL,
[frt_inactive_date] [datetime] NULL
)
GO
showing the contraint definition was bad.
Somehow, the contraint was not showing in the diagrams, or design wizards in Enterprise Manager. :shock: SQL Compare generated the script as it should have. [image] After the correction to our table was made, SQL Compare worked fine, and saved us a great deal of time.
Thank you for the assistance. / comments
Nothing came back fromselect name from sysobjects where name like 'DF_field_reporter_text_frt_lang_code
frt_lang_%' AND xtype='F'
but that made me dig deeper into our database, and that is wher...
syntax error in the SQL script
The 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'Droppi...