Copy table with ODBC

  • Thread starter Thread starter Tomek
  • Start date Start date
T

Tomek

Hi,
I'm new in C# programming. I received an order to create application
with ODBC technology. Application seems to be simple, It should copy
table from database, for example SQL server, to another database, for
example MySQL. I found solution with SqlBulkCopy, but I stuck with
ODBC. Do you have any idea how to do that?
Thank you in advance.
Tomasz
 
Tomasz,

I wouldn't use C# for this. This is EXACTLY what Data Transformation
Services in SQL Server is used for. Sql Server 2000 and 2005 support DTS.
You can create a reusable package and then execute that whenever you wish.

Hope this helps.
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Connecting to Mysql via ODBC 5.0 2
sqlServer - ODBC - WebServices 3
VBA Excel - Select a value from one cell in Excel to update a SQL table 1
returning a list of table objects from a connection 1
ERROR [IM002] [Microsoft][ODBC Driver Manager] 8
Access2010 redistribuible + runtime e ODBC issue 2
Can ODBC be accessed from remote clients? 2
Looking for a SqlBulkCopy that can do UPDATE... 5

Back
Top