Copying certain database tables for use in another application

[she...@gmail.com]

I need some help picking a good method for copying SQL tables from
C#. The trouble is I don't even know if I want to "copy" or "export"
them.

The idea is to grab some tables that the customer is using (that
contain config info and such for our application) and then install
them locally so the in-house application can use those tables for
configuration so we can use them for diagnostic purposes. We don't
need all tables in the database. Sometimes we want all the rows in a
table and sometimes we only want a subset of rows. What would be a
good way to get these tables from the customer? I was going to export
them to XML (mainly because I know how to do it easily from C#) but
some developers said I should copy them as SQL table files instead.
To save them in SQL database format or whatever the heck you'd call
that... I believe you need a database file which then contains the
tables and I'm not sure how to do this in C#. Or maybe there's
another way that makes more sense. Any suggestions?

Thanks,
Shea

[Uri Dimant]

Hi

> that... I believe you need a database file which then contains the
> tables and I'm not sure how to do this in C#. Or maybe there's
> another way that makes more sense. Any suggestions?

You have to install a database on the server and use DTS/SSIS (SQL Server
2005) to export the tables

<she...@gmail.com> wrote in message
news:2b026cee-13b8-4943...@v4g2000hsf.googlegroups.com...

[she...@gmail.com]

> You have to install a database on the server and use DTS/SSIS (SQL Server
> 2005) to export the tables

Is that something you can do programmatically using C#? I don't want
the user in SQL exterprise manager trying to export tables.