Distributing Data with an App

I have developed an application which will be distributed. I know how to
create a SQL script which will create the table structure for the DB. Is
there an easy/recommended way to export the default data from my tables in a
way which will be easy and/or automatic for the installer to load into their
DB after the tables are created?
I could write C# into my app which will notice empty tables and populate
them but this seems tedious. Is there a better way?
thanks
charles
You could BCP or BULK COPY your data or you could create insert statements
with a tool like one of these:
ObjectScripter -- http://www.rac4sql.net/
QALite -- http://www.rac4sql.net/
Lockwood Tech -- http://www.lockwoodtech.com/
Largo SQL Tools -- http://www.largosqltools.com/ (seems to be under
construction at the moment)
Keith
"charles" <spam@.synthigence.com> wrote in message
news:eoeNK4AnEHA.556@.tk2msftngp13.phx.gbl...
> I have developed an application which will be distributed. I know how to
> create a SQL script which will create the table structure for the DB. Is
> there an easy/recommended way to export the default data from my tables in
a
> way which will be easy and/or automatic for the installer to load into
their
> DB after the tables are created?
> I could write C# into my app which will notice empty tables and populate
> them but this seems tedious. Is there a better way?
> thanks
> charles
>
|||Thank you so much... QALite looks like it does exactly what I need,
creating a SQL INSERTs script from my existing data
charles
"Keith Kratochvil" <sqlguy.back2u@.comcast.net> wrote in message
news:epWH5BBnEHA.3472@.TK2MSFTNGP09.phx.gbl...[vbcol=seagreen]
> You could BCP or BULK COPY your data or you could create insert statements
> with a tool like one of these:
> ObjectScripter -- http://www.rac4sql.net/
> QALite -- http://www.rac4sql.net/
> Lockwood Tech -- http://www.lockwoodtech.com/
> Largo SQL Tools -- http://www.largosqltools.com/ (seems to be under
> construction at the moment)
> --
> Keith
>
> "charles" <spam@.synthigence.com> wrote in message
> news:eoeNK4AnEHA.556@.tk2msftngp13.phx.gbl...
to[vbcol=seagreen]
Is[vbcol=seagreen]
in
> a
> their
>