creating an existing db schema baseline

[wukie]

What is the best method of creating schema creation scripts that can be
stored into a version control system. The process of using em to
generate a script is not an appealing option. I am still learning the
MS Sql sys tables and have not found a useful list of all the codes &
types to join the tables etc.



mike


--
Posted via http://dbforums.com

[Sinisa Catic]

Re: creating an existing db schema baseline

wukie <member30544@db forums.com> wrote in message news:<3242331.1 060980041@dbfor ums.com>...[color=blue]
> What is the best method of creating schema creation scripts that can be
> stored into a version control system. The process of using em to
> generate a script is not an appealing option. I am still learning the
> MS Sql sys tables and have not found a useful list of all the codes &
> types to join the tables etc.
>
>
>
> mike[/color]

I don't like the fact that all source code versioning systems are
using proprietary files instead of proven relational databases
(SourceSafe is not exception from this). The reasons for this are
probably RDBMS licensing costs in the past.

Database schema can be exported also as XML file, which can be further
manipulated. If you and your team have serious schema versioning needs
I suggest you to evaluate Meta Data Services in SQL Server 2000 and
XML. One article about this has been published in the MSDN Magazine:

http://msdn.microsoft.com/msdnmag/issues/03/05/MetaDataServices/default.aspx

Metadata Repository can be created not only through Enterprise Manager
but also programmaticall y using Meta Data API. Further information
with examples can be found in Meta Data Services SDK 3.0, which can be
downloaded for free.


Sinisa Catic

[wukie]

Re: creating an existing db schema baseline


found what I was looking for...



in EM > Tools > Generate SQL Scripts. THis will create the total schema
of the existing database.





mike



any known issues with this tool????


--
Posted via http://dbforums.com