0

Client need with round 500,000 data in csv/xlsx format for every two month, which we currently follow the procedure by manually copy 60,000 records one time in csv/xlsx then download after passing multiple servers and finally merge all csv/xlsx in one csv, their is also chance of error while compiling all data. We need shortcut for copying large amount data(round 500,000 records) from Microsoft SQL Server 2008 R2 in one time. Please suggest better way. Thanks

DoNotArrestMe
  • 1,285
  • 1
  • 9
  • 20
khawarPK
  • 2,179
  • 4
  • 20
  • 31
  • if you must do it from sql server, just create linked servers in ssms and union them all, and save the output as CSV. –  Jan 28 '14 at 07:26
  • Can't you just bulk export the whole data in CSV format to a shared folder and fetch that? – Kahn Jan 28 '14 at 07:42
  • http://stackoverflow.com/questions/425379/how-to-export-data-as-csv-format-from-sql-server-using-sqlcmd – Anto Raja Prakash Jan 28 '14 at 07:45

0 Answers0