Hi friends,
Can any one help me in, How can i read the data from MSSQl server (Let us say at x database and all tables in that database) and then convert data in to a text format and so that i can save and upload that data into MySql Data base.
I was following a procedure which is satisfactory for few tables but as the table number and size grows my procedure will become a tedious one.
Anyhow i will tell the procedure i am following
I created a DataIntegrationServices Project which is available in MSSQL2005 server Business Intelligence Development Studio.
There i created a dataflowtask where we can give the origin and destination files. Origin was a OLEDB connection to connect the database and destination was a FlatFile. In this way i can convert data from one table to the text format with delimiters we select.
But i need to convert some hundred tables, can any one help me in this regard.
I use C# language for developing my applications.
Can any one suggest me an alternative or enhance the same procedure by certain modifications.
Please don't suggest third party tools which i have to buy, i prefer working with code or free available tools.
Thank you in advance.
N.Raghavendran.

Why not just use integration services and connect directly to MySql? You can connect to an OleDb data source which I'm sure you can do with mySql. Moving the data thru flat files seems to be a painfully unnecessary step.

-Peter

Hi planoie,
Thanks for ur reply.
But can u say how can i connect directly to mysql using oledb.
How can i establish the connection between MSSQL databse to Mysql databse and transfer the data (Source is MSSQL and Destination is MYsql database)
I have ODBC driver 3.5.1 and also mysql connector 5.0.8.1.
ALso i had downloaded a dll for Bulk Export Task from integration services u adviced.
Do u have any idea how can i implement that?
Thank you.

You can either use the OLEDB for ODBC driver, or download a MySQL OLEDB driver (I think such a think exists).

/- Sam Judson : Wrox Technical Editor -/