Solved

How to deploy LocalDB to SQL Server 2012

Posted on 2016-09-17
4
32 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 78

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 78

Accepted Solution

by:
David Johnson, CD, MVP earned 500 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

How to improve team productivity

Quip adds documents, spreadsheets, and tasklists to your Slack experience
- Elevate ideas to Quip docs
- Share Quip docs in Slack
- Get notified of changes to your docs
- Available on iOS/Android/Desktop/Web
- Online/Offline

Join & Write a Comment

Just a quick little trick I learned recently.  Now that I'm using jQuery with abandon in my asp.net applications, I have grown tired of the following syntax:      (CODE) I suppose it just offends my sense of decency to put inline VBScript on a…
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.
Polish reports in Access so they look terrific. Take yourself to another level. Equations, Back Color, Alternate Back Color. Write easy VBA Code. Tighten space to use less pages. Launch report from a menu, considering criteria only when it is filled…
This video demonstrates how to create an example email signature rule for a department in a company using CodeTwo Exchange Rules. The signature will be inserted beneath users' latest emails in conversations and will be displayed in users' Sent Items…

743 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

Need Help in Real-Time?

Connect with top rated Experts

15 Experts available now in Live!

Get 1:1 Help Now