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.

1 comment:

  1. I really like your ideas. I truly appreciate your effort in publishing this article. Keep it up and God bless.

    Say
    www.imarksweb.org

    ReplyDelete