Installation of Table Question

Hi,
I am developing an add on to a db application where I need to install a
couple of tables to an existing db. I am curious what others use for
installation. Do most developers use SQL scripts excuted by ossql command
in a batch file?
ThanksI find that to be the most effective way to deliver the package. However,
it's really coming down to personal preference. You can also deliver the
package by making an ado connection to the database and run your ddl against
the database.
-oj
"George" <george@.ny.com> wrote in message
news:OALHWKfoFHA.2916@.TK2MSFTNGP14.phx.gbl...
> Hi,
> I am developing an add on to a db application where I need to install a
> couple of tables to an existing db. I am curious what others use for
> installation. Do most developers use SQL scripts excuted by ossql command
> in a batch file?
> Thanks
>|||That is the way I would do it. I find it reassuring as a dba to be able to
view queries that will be executed against the database. At least one
application I support does it like oj suggested and it makes me feel kind of
uneasy to run the rather frequent upgrade programs. I would probably like
to see the setup program launch the change script, if possible. I would use
OSQL to do it because it natively supports GO batch separators and it makes
writing code like this more natural, and OSQL gives you everything you need.
I guess the most important thing to ask is who will be using this upgrade?
Just your corporate user or is this a commercial application.
----
Louis Davidson - http://spaces.msn.com/members/drsql/
SQL Server MVP
"George" <george@.ny.com> wrote in message
news:OALHWKfoFHA.2916@.TK2MSFTNGP14.phx.gbl...
> Hi,
> I am developing an add on to a db application where I need to install a
> couple of tables to an existing db. I am curious what others use for
> installation. Do most developers use SQL scripts excuted by ossql command
> in a batch file?
> Thanks
>