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.
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