New answers tagged export
One option is to use the SqlBulkCopy class via SQLCLR. You can either code this yourself or simply download the Free version of SQL# (which I am the author of) which contains a stored procedure named DB_BulkCopy which encapsulates this functionality. In either case the assembly will need to be given a PERMISSION_SET of EXTERNAL_ACCESS. If using the SQL# ...
I restored the database's backup on the target server and issued an insert into select.
The simplest method which we use is something like below Create a table on destination server using the scripts generated from the table on the source server by right click and going through option of Tasks/Generate scripts. Then run the below T-SQL to upload the data from source table to destination. INSERT INTO dbo.YourTableNameHere SELECT * FROM ...
Top 50 recent answers are included