SQL Server 2014 - Import and Export Wizard

[Costas]

reference - http://stackoverflow.com/a/29712653

Use the SQL Server Import and Export Wizard, and choose New... when choosing the destination database.

Right Click Database > Tasks > Import Data.

Choose a Data Source

Data Source: SQL Server Native Client
Server Name: the remote server
Authentication:
Database: the db name
Choose a Destination

Data Source: SQL Server Native Client
Server Name: the local server
Authentication:
Database: New...
The rest is straight forward.


Picture It!