Hello Gyus,
I'm facing one problem since three days, actually I want to import sql data in sql and perform some filtration on it, export it in txt file. So I want to know whether is any tool which solve such kinds of problem or any option in sql server through which we could solve it.
Please resolve my problem as soon as possible.
Thanks in advance!!!
Hi Gaurav Yadav,
To import sql file in sql server you don't need to do anything, just simply click on sql file its open in sql server by default. But in case of export sql data in txt file, to perform this action just simply click on 'Result To File' option from toolbar, now execute your query then data will be saved in rtf format file. Rename extension of file and replace .rtf to txt file. But in case using third party software you could use MindStick DataConverter. It is free charge tool which perform import and export data in many formats. You can download this software by clicking following link.
MindStick DataConverter Downloads Link: http://mindstick.com/Product/ProductDC.aspx
I hope it might be useful.
The best option to resolve this problem is MS-Excel and MSSQL Server. Because of they have facility to import and export data in csv file yet if you want to use any tool then there are lots of tool in the market which performed data conversion task. MindStick DataConverter is also a such types of tool which helped me lot.
When you are doing import and export on the database that time you should need to understand that it will effect on the database. You can insert data from one database to another but it will did through the expert person. You can expert data from one table to another easily.