Multiple tables data extraction
down votefavorite

I want to extract data from 100 tables in a one go in SQL Server 2008 R2. Is there any option? I am extracting through SSIS but need to work manually for all tables and its not a generic method.

In oracle i am doing this with spool option. And running a script file which is generating csv data for 100 tables.

Looking for your expert suggestions.

Regards Irfan Ahmad
November 21st, 2013 12:29am

You can script out the data but if it is huge it takes time.

http://blogs.msdn.com/b/davidlean/archive/2009/09/20/tip-ssms-script-your-entire-table-including-the-data-a-hidden-gem.aspx

Free Windows Admin Tool Kit Click here and download it now
November 21st, 2013 2:43am

This topic is archived. No further replies will be accepted.

Other recent topics Other recent topics