Hello All!

I was put in charge of a database that has absolutely no build scripts or source code (no source control at all).

Is there a way to extract all objects in the database to individual files (stored procedure create, table create, etc) into a Visual Studio database project so that I can deploy elsewhere if needed?

I know you can do this (sort of) with the Script Wizard in Management Studio, but I'd like to create all the objects into individual files so I can add to source management.

I dug around in VS 2005 and VS 2008 database projects, but didn't see off hand if it is possible.

Thanks
Jay

I wish there was a simple solution to this but I'm 99% sure there is not.  I was in the same situation not too long ago and as a temporary solution I've exported every object type into its own file, i.e. CreateTables, CreateStoredProces, etc.  We are gradually moving items into their own files as we touch them to make updates.

I just used the export functionality in Management Studio to take care of it, and the biggest issue I ran into while doing it was that it doesn't take dependencies into consideration when exporting Views.  I exported all my views, and if I tried to run the create script it generated, it would fail.  I had to re-order them all by hand to get it to work.

Wow, that seems really strange!  All the functionality is basically there in VS, I thought this would be pretty easy, dang.  I just downloaded Visual Studio 2010 Beta 2, perhaps there is something in the newest version.

Thanks
Jay