What are the challenges you face when working across database platforms? Take the survey
Options

Running script from own application

Brian DonahueBrian Donahue Posts: 6,590 Bronze 1
edited January 23, 2004 9:46AM in SQL Compare Previous Versions
Hi Shloma,

Maybe I can help. What language are you coding in, and what methods are
you trying to use to run the script on the server?

Thanks,

Brian Donahue
Red Gate Technical Support

"Shloma Baum" <test@msn.com> wrote in message
news:nUH$73q3DHA.1248@server53...
> Hi,
>
> I downloaded the SQL Compare, its simply amazing!.
>
> But just one question, I'm a software developers and my application
uses
> sql server for its databaase backend, and I would use sql compare to
script
> database changes that I have made since the last update that I have sended
> to my clients, and I would create a script file and ship it with the next
> update to my clients, everything is fine here, but just one annoying
thing,
> I "Dont" want to use OSQL to run the scripts since I can't control exactly
> what's going on, see all error messeges, ect. so I would like to run it
from
> within my application, now the only question is that I can't see to get
sql
> server to recognize the GO commands, since the sql compare script is made
of
> sepperate batches (which is need to for some TSql statements that needs to
> be at the beginging of a batch) and it seems to me that you can't run a
sql
> of sepperate batches from one call, could anyone help me with this?
>
> Thanks in advance
> Shloma
>
>
This discussion has been closed.