Hi there,
I was wondering if anyone has any links to tutorials or walk throughs for managing db's with vsts Database edition?
Specifically i am looking how to do source control with visualsvn?
I have downloaded the R2 GDR which updated my vs 2008 with the sql server 2008 templates
I don't have a problem with vs 2008 but i am bit confused with the db edition and would love to take advantage of the source control as well of other db stuff..
Can anyone help?
thanks
If you make a database project then you can save your database constructs as files on the hard drive. Everything is a separate file, so every constraint, stored procedure, etc.
But, this makes it easier to save the database to a source control system.
Unless you are making lots of changes you will want to not have this database project be built on a regular basis from your project, otherwise everyone on your team needs to have a .dbml file checked out, as that gets modified every time.
I haven't tried it, but it may make sense not to include this file in the source control so that it won't need to be checked out by everyone.