Options
Command Line SQLCompare
Brian Donahue
Posts: 6,590 Bronze 1
Hi Jamie,
There are no compare options in SQL Compare or Data Compare that you can
use. Everything is done interactively through the GUI. What we can offer is
the SQL Toolkit, which is an SDK for our products. If you can use ActiveX
technology in the Windows implementation of Perl, you could build a solution
around this. I have seen the Red Gate COM objects used successfully with
J(ava)Script in the past, but I'm unsure if you have this capability in
Perl.
For more information on SQL Toolkit:
http://www.red-gate.com/sql_comparison_ ... oolkit.htm
Thanks,
Brian Donahue
Red Gate Technical Support
"Jamie French" <jamie_french@[no spam]aimtechnology.com> wrote in message
news:N%23tjwFImDHA.1488@server53...
> Hi Guys,
>
> I believe SQLCompare is unable to work from a command line. I need to
> somehow incorporate SQLCompare within a perl script to generate compare
> files automatically every night. Any ideas?
>
> Take Care,
>
> Jamie
>
>
There are no compare options in SQL Compare or Data Compare that you can
use. Everything is done interactively through the GUI. What we can offer is
the SQL Toolkit, which is an SDK for our products. If you can use ActiveX
technology in the Windows implementation of Perl, you could build a solution
around this. I have seen the Red Gate COM objects used successfully with
J(ava)Script in the past, but I'm unsure if you have this capability in
Perl.
For more information on SQL Toolkit:
http://www.red-gate.com/sql_comparison_ ... oolkit.htm
Thanks,
Brian Donahue
Red Gate Technical Support
"Jamie French" <jamie_french@[no spam]aimtechnology.com> wrote in message
news:N%23tjwFImDHA.1488@server53...
> Hi Guys,
>
> I believe SQLCompare is unable to work from a command line. I need to
> somehow incorporate SQLCompare within a perl script to generate compare
> files automatically every night. Any ideas?
>
> Take Care,
>
> Jamie
>
>
This discussion has been closed.
Comments
Okay. But be sure to check with us in a few weeks. We're going to change
the way that the Toolkit is sold and priced. It most likely won't even be
called Toolkit any more.
"Jamie French" <jamie_french@[no spam]aimtechnology.com> wrote in message
news:R8wxsZLmDHA.1012@server53...
> Hi Brian,
>
> Many thanks for your prompt response. This would be an ideal, though at
the
> quoted price I am sure this would not get approved.
>
> Best Regards,
>
> Jamie
>
> "Brian Donahue (Red Gate)" <brian.donahue@red-gate.com> wrote in message
> news:fbXeYMKmDHA.1488@server53...
> > Hi Jamie,
> >
> > There are no compare options in SQL Compare or Data Compare that you
> can
> > use. Everything is done interactively through the GUI. What we can offer
> is
> > the SQL Toolkit, which is an SDK for our products. If you can use
ActiveX
> > technology in the Windows implementation of Perl, you could build a
> solution
> > around this. I have seen the Red Gate COM objects used successfully with
> > J(ava)Script in the past, but I'm unsure if you have this capability in
> > Perl.
> >
> > For more information on SQL Toolkit:
> > http://www.red-gate.com/sql_comparison_ ... oolkit.htm
> >
> > Thanks,
> >
> > Brian Donahue
> > Red Gate Technical Support
> >
> > "Jamie French" <jamie_french@[no spam]aimtechnology.com> wrote in
message
> > news:N%23tjwFImDHA.1488@server53...
> > > Hi Guys,
> > >
> > > I believe SQLCompare is unable to work from a command line. I need to
> > > somehow incorporate SQLCompare within a perl script to generate
compare
> > > files automatically every night. Any ideas?
> > >
> > > Take Care,
> > >
> > > Jamie
> > >
> > >
> >
> >
>
>