If you ever need to create a database project based off of an existing database, here's a link that shows you how to do it very quickly and easily with VS 2010.
Link
You may want to do this if you want to save your schema and things like that in source control.
Another neat advantage to creating a database project is that you can actually compile it and it will show you any errors you may have buried deep in your database. We did this recently on one of our databases and realized that we had a few Views that were no longer being used, and that referenced column names that no longer existed. Without using a DB project and trying to compile, those views probably would have sat on that database untouched for the rest of time.
Subscribe to:
Post Comments (Atom)
Posts
No comments:
Post a Comment