Syntax Error in generate script (=bug?)
robleenheer
Posts: 2
SQL Compare generates the following script:
ALTER TABLE [dbo].[tblCurrency] DROP CONSTRAINT [[dbo].[tblCurrency]CurrencyDefault]
which causes an error when run against the target database.
The correct syntax is:
ALTER TABLE [dbo].[tblCurrency] DROP CONSTRAINT dbo][b[/b].[tblCurrency]]CurrencyDefault]
(see 2x square bracket added).
If I manually go through the errors in the script and update them as above, the entire script runs fine.
The test environment is SQLExpress2008.
Anyone's comments?!
ALTER TABLE [dbo].[tblCurrency] DROP CONSTRAINT [[dbo].[tblCurrency]CurrencyDefault]
which causes an error when run against the target database.
The correct syntax is:
ALTER TABLE [dbo].[tblCurrency] DROP CONSTRAINT dbo][b[/b].[tblCurrency]]CurrencyDefault]
(see 2x square bracket added).
If I manually go through the errors in the script and update them as above, the entire script runs fine.
The test environment is SQLExpress2008.
Anyone's comments?!
Comments
If so, that's a known issue (SC-3375) which I've now added your report to - I'm not sure what the timescale for fixing it is, alas.
Redgate Software