The way to import a table from one SQL Server to another SQL Server is very easy.
SQL Server provides a feature to Import and Export data or complete objects to another or even the same environment. That utility is Import and Export Wizard in SQL Server Management Studio (SSMS). The Import and Export Wizard provides the facility to import or export data/objects between different data sources like flat file, SQL Server, Sybase, MySQL, Oracle, Access and Excel etc.
There are multiple ways to import or export. A few of them are given below for your knowledge. Suppose we want to import a table from one SQL Server to another SQL Server:
Step 1: Connect to the Source SQL Server Instance.
