0

I'm looking for an easy way to run an SQL file on my SQL Express from Visual Studio Express.

When not using express, this way is nice and easy.

So far, using sqlcmd seems like my fastest option (i have a batch file for easy drag and drop purposes).

Anyone know of a neater way to update my DB from my Entity model?

TIA

ericosg
  • 4,926
  • 4
  • 37
  • 59

1 Answers1

0

I'll just post my method in doing this, as without any other software etc, it still seems the easiest way.

sqlcmd -S .\sqlexpress -i "%~1"
pause

I made a .bat file with the above, which allows me to drag and drop .sql files and have them run against my DB.

ericosg
  • 4,926
  • 4
  • 37
  • 59