0

I've had to reinstall my OS so have lost the development Sql LocalDb instance of my website's database.

However, I do have the live database on my production server.

I want to recreate my LocalDb from the live database.

How do I do this?

I used to transfer data between production and development (and vice versa) using backup and restore but my new clean installation of windows does not have SQL Express anymore.

I guess I could generate scripts but I'm not sure if that would successfully create a localdb instance.

FloatLeft
  • 1,317
  • 3
  • 23
  • 40
  • Why can't you reinstall SQL Express? – James S Oct 22 '13 at 08:30
  • Yes, I could do that. However as LocalDB is Microsoft's 'recommended database engine' I thought I would see how I could work within those constraints. However it looks like I'll need to at least download/install Management Studio – FloatLeft Oct 22 '13 at 08:46
  • Installing Management Studio allowed me to use the backup/restore method. However, I do wonder how this could be done from within Visual Studio. – FloatLeft Oct 22 '13 at 09:08

0 Answers0