How can we help you today? How can we help you today?

Issue when synchronizing Trigger in a diffirent schema

I have trigger in table and table is in not in a defult schema. I have create trigger using

CREATE TRIGGER trgname ON TableName ...

Normally I won't specify the schema name as schema will be created in the schema of the table.

After creating of a schema, I can use SQL compare to move the CREATE Trigger script/

Problem exists when I do any changes to the trigger.

After doing any changes when you generate scripts from the SQL Compare, it generates

ALTER triggername ON tablename

But sql server needs following format

ALTER schemaname.triggername on TABLEname
dineshasanka
0

Comments

1 comment

Sort by
  • Simon C
    Textual object renames are one of the perennial problems of SQL Compare; as the actual object text is stored in SQL Server, we have to refactor objects as we go. We currently don't do this for DML triggers, however there is a bug about it (SC-3926) that is due to be fixed for the 8.0 release.

    Simon C
    Simon C
    0

Add comment

Please sign in to leave a comment.