Toad World® Forums

anyone ever seen all duplicate column names generated for "syncronize" script?


#1

This was generated by TDM doing a syncronize, generate alter scripts:

CREATE TABLE [dfsi].[_FSIQueries]

(

[QueryID] Int IDENTITY(1,1) NOT NULL,

[QueryID] Int IDENTITY(1,1) NOT NULL,

[QuerySqlName] Sysname NOT NULL,

[QuerySqlName] Sysname NOT NULL,

[QuerySqlSchema] Sysname NOT NULL,

[QuerySqlSchema] Sysname NOT NULL,

[QueryFriendlyName] Varchar(100) NOT NULL,

[QueryFriendlyName] Varchar(100) NOT NULL,

[QueryIsEnabled] Bit NOT NULL,

[QueryIsEnabled] Bit NOT NULL,

[CreatedDateTime] Datetime CONSTRAINT [_FSIQueriesCrtDt] DEFAULT (getdate()) NOT NULL,

[CreatedDateTime] Datetime CONSTRAINT [_FSIQueriesCrtDt] DEFAULT (getdate()) NOT NULL,

[LastModifiedDateTime] Datetime NOT NULL,

[LastModifiedDateTime] Datetime NOT NULL,

[CreatedUserName] Varchar(100) CONSTRAINT [FSIQueriesCrtUname] DEFAULT ((suser_sname()+’’)+host_name()) NOT NULL,

[CreatedUserName] Varchar(100) CONSTRAINT [FSIQueriesCrtUname] DEFAULT ((suser_sname()+’’)+host_name()) NOT NULL,

[QueryHelp] Varchar(1000) NULL,

[QueryHelp] Varchar(1000) NULL

)


#2

Hi Ken,

I guess you’re using TDM 5.1. Right? What MS SQL version do you use? Do you perform the alter script for model (model file .txp) or database (RE connection)?

The ideal thing would be if you could send us a sample model (e.g. just the tables where the problem occurs). If you cannot, please write us as many details as possible so as we can simulate the problem.

Thanks!

Regards, Vladka