Overview:
Cloning tables between databases in SQL Server can be efficiently achieved through the use of the built-in export and import functions. This process involves exporting data from the source database, including table structures and content, and subsequently importing it into the target database.
Step 1:
Right click on the database in which the tables are present, click task from the popup menu and then select export option.
Step 2:
Select database source as sql native client, select the server name and provide the database name in which the tables are present in which we are going to export
Step 3:
Select destination as sql native client and provide the server name and database name in which we are going import the table
Step 4:
Choose the first option and click next
Step 5:
From the source database select the tables which we want to export
Step 6:
Click Run immediate check box and click next.
Step 7:
Verify the options which we provided earlier are correct and click Finish
Step 8:
Check the completion status and close the window.
Step 9:
In the import_db database we can see emp table is imported successfully.
