Question: how to export all table data in sql server?
Answer: Right-click on the database that contains tables you wish to export. ...  Click Next > on the Introduction page. ...  On the Choose Objects page, select all of the tables you wish to export. ...  On the Set Scripting Options page, select Save scripts to a specific location.