Options
if exist/drop provision
Neil Davidson
Posts: 281
Jim,
There is no way of doing this. If you are trying to synchronize multiple
databases with a single 'master' one then you could write a .NET application
to access SQL Toolkit to automate SQL Compare to do exactly what you want.
That would be a safer solution.
Yours,
Neil
"Jim" <jim@nospam.com> wrote in message news:eNItx2NEEHA.1504@server53...
> Is there a way to cause SQL Compare to add an if exists/drop to any or all
> of the script commands it creates? We have a situation where the
databases
> the script changes will be applied to may already have some of the
changes,
> in particular indexes.
>
> Thank you in advance.
>
>
There is no way of doing this. If you are trying to synchronize multiple
databases with a single 'master' one then you could write a .NET application
to access SQL Toolkit to automate SQL Compare to do exactly what you want.
That would be a safer solution.
Yours,
Neil
"Jim" <jim@nospam.com> wrote in message news:eNItx2NEEHA.1504@server53...
> Is there a way to cause SQL Compare to add an if exists/drop to any or all
> of the script commands it creates? We have a situation where the
databases
> the script changes will be applied to may already have some of the
changes,
> in particular indexes.
>
> Thank you in advance.
>
>
- Neil Davidson
Red Gate Software Ltd
Red Gate Software Ltd
This discussion has been closed.
