Can the Export Wizard export data to another database server? (4279851)

Return

Feedback Submitted

Did this article solve an issue for you?

Select Rating

Title

Can the Export Wizard export data to another database server?
Description

The Export Wizard has an output format call "Create as New Table." Can itcreate anewtable in another server and export the data to the newly created table on that server?
Resolution

The "Create as New Table" only allow you to go to any schema within the server that you are currently connected to.
WORKAROUND:
1. Generate the TABLE script from the table in question
   a. In the Object Explorer, right click and select 'Create Like' to get the table script
   b. Copy and paste it somewhere
Â
2. Generate the INSERT script for the table
   a. From the Export Wizard, select the output format 'SQL Script'
   b. Run to the end of the wizard and send the output to a file
   c. Go to where you saved the output and open the file
Â
3. Make a new connection to the new server and copy and paste the TABLE and INSERT script into the Editor and run the scripts

Feedback Submitted

Did this article solve an issue for you?

Select Rating

Title