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.

Scripting Procedure from LocalDB to SQL Server

While using LocalDB, we get error scripting procedures "Index out of Bound".
So, currently we have scripted all procedures individually and executed it on SQL Server.

It is basically server issue and we dont have a solution at the moment.