how to export table data in sql server 2012?
Right-click on the name of the database instance you want to use, and select Export Data from the Tasks menu. Click Next. Choose SQL Server Native Client as your data source. Choose the name of the server that you want to export data from in the Server Name dropdown box.