?
Solved

How to deploy LocalDB to SQL Server 2012

Posted on 2016-09-17
4
Medium Priority
?
174 Views
Last Modified: 2016-09-17
I've created a .net mvc solution using code-first entity framework v6.  I'm ready to deploy this solution to SQL Server 2012.  How can I deploy my LocalDB schema and seeds to the production server?  

Future updates will no doubt also modify the schema (new tables, new columns, new seed data).  How can I sync the changes I make to LocalDB to SQL Server 2012?
0
Comment
Question by:canuckconsulting
  • 2
  • 2
4 Comments
 
LVL 85

Expert Comment

by:David Johnson, CD, MVP
ID: 41803081
Connection string
"Server=(localdb)\\Test;Integrated Security=true;AttachDbFileName= myDbFile;"
0
 

Author Comment

by:canuckconsulting
ID: 41803089
David I don't think I understand what you are trying to convey.  Would you please elaborate?

Thanks,

Scott
0
 
LVL 85

Accepted Solution

by:
David Johnson, CD, MVP earned 2000 total points
ID: 41803095
How can I deploy my LocalDB schema and seeds to the production server?   Publish your application to the production server.
0
 

Author Closing Comment

by:canuckconsulting
ID: 41803385
Well that was easy...cheers!
0

Featured Post

Free Tool: Port Scanner

Check which ports are open to the outside world. Helps make sure that your firewall rules are working as intended.

One of a set of tools we are providing to everyone as a way of saying thank you for being a part of the community.

Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

Join & Write a Comment

Calculating holidays and working days is a function that is often needed yet it is not one found within the Framework. This article presents one approach to building a working-day calculator for use in .NET.
In real business world data are crucial and sometimes data are shared among different information systems. Hence, an agreeable file transfer protocol need to be established.
The video will let you know the exact process to import OST/PST files to the cloud based Office 365 mailboxes. Using Kernel Import PST to Office 365 tool, one can quickly import numerous OST/PST files to Office 365. Besides this, the tool also comes…
When you have multiple client accounts to manage, it often feels like there aren’t enough hours in the day. With too many applications to juggle, you can’t focus on your clients, much less your growing to-do list. But that doesn’t have to be the cas…

589 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question