How to move the tables to another database in MS SQL
SQL is a common database language that comes in many flavors. Microsoft MS SQL works with the Microsoft server and can be used as the back-end database for several programming languages. When it comes to transferring a collection of tables from one database to another in MS SQL, you must use Microsoft SQL Server Management Studio, which is included in MS SQL since 2005.
Steps to follow:one
Launch Microsoft SQL Server Management Studio. Click to expand the trees in the "Database".
two
Click on the database to which you want to transfer tables, and then click on "Tasks" in the context menu. Click on the "Import" article.
3
Click to select "SQL Server Native Client" from the "Source" drop-down box. Click to select the local server name from the "Server Name" drop-down box.
4
Click on the "Database" drop-down box and select the database you want to copy. Click on the "Next" button to continue.
5
Click on the box next to "Copy data from one or more tables or views". Then, click on the "Next" button.
6
Click on the boxes next to the tables you want to import, and finally, click on the "Next" button to begin the transfer.
