Anybody please tell me basic idea to create a tool which should be able to export data from SQL Server. I am familiar with java and MS SQL. Please help me. Thanx in advance.
I suggest you to use Microsoft SQL Server 2005 Integration Services (SSIS). - It is a platform for building high performance data integration solutions, including the extraction, transformation, and loading (ETL) of packages for data warehousing. Take a look at - How to: Run the SQL Server Import and Export Wizard?