Please start any new threads on our new site at https://forums.sqlteam.com. We've got lots of great SQL Server experts to answer whatever question you can come up with.

 All Forums
 SQL Server 2005 Forums
 SQL Server Administration (2005)
 Proper deployment of new database and upgrades?

Author  Topic 

corecomps
Starting Member

2 Posts

Posted - 2009-02-05 : 23:28:54
I am a .Net programmer turned Development manager. We have a fairly simple database setup to store the basics. A contractor we recently needed to let go due to the economic conditions was our "DB Guy". Basically he created a seemingly over complex method to basically re-receate tables and load procs int the database. Seems like the hard way of doing things and I'm surprised that VS 2008 doesn't have a better way for us to automate things a little better.

My question is this. Can I use visual studio to help me create database deployment scripts for both new table/procs and updated table/procs?

Obviously part of upgrades are scripts to undo changes. This is something I thought Visual Studio 2008 would be good at.

I do have MSDN for the developers including VS 2008 DB version.

Any links or tips would be valuable.
   

- Advertisement -