How to export all tables in a database with data in SQL Server??

• gary1

  SSC-Insane

  Points: 21152

  More actions

  February 9, 2015 at 4:16 pm

  #294602

  How to export all tables in a database with data in SQL Server??

  We don't want any other objects other than tables and that's why we are not going with full backups. Please advise

• gary1

  SSC-Insane

  Points: 21152

  More actions

  February 9, 2015 at 4:25 pm

  #1776504

  I did find a way from the below link:

  http://blogs.msdn.com/b/tfssetup/archive/2012/01/09/exporting-selected-tables-from-a-sql-database.aspx

  We have more than 50 databases. Using import/export is time consuming. Is there any scripted way to do this?

• Steve Jones - SSC Editor

  SSC Guru

  Points: 736193

  More actions

  February 9, 2015 at 4:53 pm

  #1776505

  Use one of these scripts: http://www.sqlservercentral.com/search/?q=bcp+all+out&t=s&sort=relevance

  BCP is the fastest way. I have a script up there to export all tables. There are corresponding scripts to pull all the data in.