Is this a pretty close approximation of the DB Pro directory structure? We may or may not get the Team Edition for DB Professionals in the future, but if this structure is very similar, we can start using this to check our objects into source control. This looks like a pretty good project, especially with the difficulty of scripting objects in SQL 2005.
Thank you for your work.
-Peter Schott
If you would like to refer to this comment somewhere else in this project, copy and paste the following link:
The directory structure is identical to that produced by Visual Studio for Database Professionals [DB Pro]. Additionally, the filenames match those created by DB Pro. It produces files for all but a couple of the object types for both SQL Server 2000 and 2005 databases [e.g., no Service Broker objects at this time].
Richard
P.S. By next week this project will also include a command file which will automatically deploy the files [if they follow the directory structure].
If you would like to refer to this comment somewhere else in this project, copy and paste the following link:
Is this a pretty close approximation of the DB Pro directory structure? We may or may not get the Team Edition for DB Professionals in the future, but if this structure is very similar, we can start using this to check our objects into source control. This looks like a pretty good project, especially with the difficulty of scripting objects in SQL 2005.
Thank you for your work.
-Peter Schott
The directory structure is identical to that produced by Visual Studio for Database Professionals [DB Pro]. Additionally, the filenames match those created by DB Pro. It produces files for all but a couple of the object types for both SQL Server 2000 and 2005 databases [e.g., no Service Broker objects at this time].
Richard
P.S. By next week this project will also include a command file which will automatically deploy the files [if they follow the directory structure].