Reading data from ms sql
-
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
-
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
There is an open source tool here that might do what you're after. Google is your friend. Use him, that's what friends are for.;P
"You're very clever, young man, very clever," said the old lady. "But it's turtles all the way down!"