Skip to content
← SQL Source Control

How can we improve SQL Source Control?

SQL Source Control

Categories

JUMP TO ANOTHER FORUM

(thinking…)

Separate triggers from tables

Please give option for DML trigger changes be tracked separately from tables. It's very annoying trying to support and enhance a trigger-heavy inherited database that needs an extensive trigger optimizations. It doesn't allow me to isolate and rollback my changes very easily ... and branching and integrating - ha! This was almost a big enough deal to send me to ApexSQL... alas, I am regretting my decision these days. It seems people have been requesting this feature in Source Control and Compare for a while... please stop pushing it aside - it's frustrating. Thanks

77 votes
Vote

We're glad you're here

Please sign in to leave feedback
Signed in as (Sign out)
Close
Close
You have left! (?) (thinking…)
John Casey Doherty shared this idea  ·   ·  Report…  ·  Admin →
How important is this to you?

We're glad you're here

Please sign in to leave feedback
Signed in as (Sign out)
Close
Close

We're glad you're here

Please sign in to leave feedback
Signed in as (Sign out)
Close
Close
Submitting...
An error occurred while saving the comment
  • Moshe Alfih commented  ·   ·  Report

    I noticed the RedGateDatabaseInfo seems to have such foresight, but alas it doesn't work. Here is an excerpt:

    <?xml version="1.0" encoding="utf-8"?>
    <DatabaseInformation Version="2">
    <WriteToFileOptions>
    <Prefixes>
    <None>
    </None>
    <Table>Tables</Table>
    <Trigger />
    </Prefixes>
    <DataWriteAllFilesInOneDirectory>True</DataWriteAllFilesInOneDirectory>
    </WriteToFileOptions>
    </DatabaseInformation>