Hi, I am in the process of transferring the data from MSSQl database to MYSQL :doh:database. I went through a code snippet which as in vb, in transferring the data (I mean content of tables). I got this info from SQL DTS.com (Bulk Export Task) can any one here who did this sort of job earlier using C#? I downloaded the required dll but wanna to have a code snippet in C#. If any one knows please help me. Thank you in advance Raghavendran.:rose:
Raghavendran
Hi, I am in the process of transferring the data from MSSQl database to MYSQL :doh:database. I went through a code snippet which as in vb, in transferring the data (I mean content of tables). I got this info from SQL DTS.com (Bulk Export Task) can any one here who did this sort of job earlier using C#? I downloaded the required dll but wanna to have a code snippet in C#. If any one knows please help me. Thank you in advance Raghavendran.
Raghavendran
Hi, Can you tell me exactly the way in which i can proceed? Setting up a task for each table in the sense how can i proceed? Should i go for workflowfoundation? or manually select each table and do the process? Is that not feasible implementing a loop? Thanks:)
Raghavendran
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 [b]MySql [/b]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.:((
Raghavendran
Hi friends,:doh: 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 [b]MySql [/b]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. :((
Raghavendran