Copy local SqlServer database with visual studio solution

Question

I've created a simple sports store (From Pro ASP.NET MVC 5 freeman) that I keep on a flash drive, due to working on my desktop computer, laptop, or a lab computer on campus. Is there an easy way to bring the database tables along with it?

arknotts · Accepted Answer · 2015-01-22 15:54:11Z

1

First, I'd recommend looking into a version control system (SVN, Git, etc). Even if you don't use it for versioning, it will--at a minimum--help you sync your code between different computers.

The simplest (yet most basic) way of bringing your database along with the code is just to add a SQL schema script along side your code and run it on the local SQL server on each machine. However, this approach has the limitation of not handling schema updates very well...which brings me to my recommended solution: use an ORM (i.e. Entity Framework) and let it handle the creation of the database. If your schema needs to change, it will automatically generate migration scripts that can update the database on your other machines.

answered Jan 22, 2015 at 15:54

arknotts

4543 silver badges13 bronze badges

Sign up to request clarification or add additional context in comments.

1 Comment

Matt Altepeter Over a year ago

Thanks for your reply, I ended up adding the .mdf to my App Data folder and that solved all of my problems

Collectives™ on Stack Overflow

Copy local SqlServer database with visual studio solution

1 Answer 1

1 Comment

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

1 Comment

Your Answer

Sign up or log in

Post as a guest

Related