By using this site, you agree to our updated Privacy Policy and our Terms of Use. Manage your Cookies Settings.
435,241 Members | 775 Online
Bytes IT Community
+ Ask a Question
Need help? Post your question and get tips & solutions from a community of 435,241 IT Pros & Developers. It's quick & easy.

Copy table with ODBC

P: n/a
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

Mar 16 '07 #1
Share this Question
Share on Google+
1 Reply


P: n/a
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.
--
- Nicholas Paldino [.NET/C# MVP]
- mv*@spam.guard.caspershouse.com

"Tomek" <ts**********@gazeta.plwrote in message
news:11**********************@l75g2000hse.googlegr oups.com...
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

Mar 18 '07 #2

This discussion thread is closed

Replies have been disabled for this discussion.