Reading data from ms sql
-
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, 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
You could use SQL Server Integration Services (SSIS) to achieve this. For each table, set up a task that writes the contents of that table out to an individual flat (text) file. This site[^] has plenty of useful resources for SSIS.
Paul Marfleet "No, his mind is not for rent To any God or government" Tom Sawyer - Rush
-
You could use SQL Server Integration Services (SSIS) to achieve this. For each table, set up a task that writes the contents of that table out to an individual flat (text) file. This site[^] has plenty of useful resources for SSIS.
Paul Marfleet "No, his mind is not for rent To any God or government" Tom Sawyer - Rush
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, 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
I'm afraid I'm not an expect in SSIS. You probably can set up a package to iterate over tables in a database but I don't know how to do that. If there are not many tables in your database and the design is not likely to change, you could manually set up tasks to export each table. I suggest you read the SSIS documentation to find out what it is capable of doing.
Paul Marfleet "No, his mind is not for rent To any God or government" Tom Sawyer - Rush