How to create a database project in Visual Studio 2013

I am porting a solution that contains some C # projects from Visual Studio 2008 to VS2013. The migration went fine, with minor adjustments, but there is also a .dbp project (database project, from VS2008) that refuses to migrate / upload to VS2013.

The closest type of project that I found in this new version is โ€œSQL Server Database Projectโ€, I created it and added my existing .sql script files, but this type of project (.sqlproj) seems to be something else. For example , VS 2008 database project is not being built. Also, it was hard for me to try adding a link to my existing SQL database running under SQLExpress.

I also set BuildAction = None for all my script files, and now I can open each one manually and execute. But still, I would like to select several files and execute them all at once . It seems I'm missing something.

So is there a way to do this?

0
source share
1 answer

I suggest you move on to the next article to convert dbp to dbproj: MSDN

And after that, look at the following link to convert dbproj to sqlproj: Tentacle Software Blog

0
source

All Articles