Thursday 5 June 2014

Data Transfer from LocalDB to SQL Server

To transfer data from LocalDB to SQL Server

Open SQL Server connection, right click on the database to which data has to be exported. Click on Tasks>Import Data..

On the popop, select datasource as SQL Server Native client 11.0,
Put "(LocalDb)\v11.0" in Server Name.
Select database.

Select Tables >> Finish..

You cannot transfer PROCEDURES AND DATATYPES... Only Table data is transfered.

No comments:

Post a Comment