Order of tables in update script
Brian Donahue
Posts: 6,590 Bronze 1
Hello Michael,
There is no way to set the table order in SQL Data Compare. I will have
to put it down as a suggestion for the future. Some support for FKs on the
same table would probably also be welcome.
Regards,
Brian Donahue
Red Gate Support
"Michael Bahn" <michael.bahn@pmigroup.com> wrote in message
news:zVlV4t1DDHA.3380@server53...
> Because of foreign key relationships, the order of the tables in the
update
> script is important when generating updates for multiple tables.
>
> Is there a way to modify the templates.xml so that the order can be set,
to
> avoid having to munge the update script to get it in the right order?
>
> Thanks,
> michael.bahn@pmigroup.com
>
>
>
There is no way to set the table order in SQL Data Compare. I will have
to put it down as a suggestion for the future. Some support for FKs on the
same table would probably also be welcome.
Regards,
Brian Donahue
Red Gate Support
"Michael Bahn" <michael.bahn@pmigroup.com> wrote in message
news:zVlV4t1DDHA.3380@server53...
> Because of foreign key relationships, the order of the tables in the
update
> script is important when generating updates for multiple tables.
>
> Is there a way to modify the templates.xml so that the order can be set,
to
> avoid having to munge the update script to get it in the right order?
>
> Thanks,
> michael.bahn@pmigroup.com
>
>
>
This discussion has been closed.
