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 2000 Forums
 SQL Server Development (2000)
 Any suggestion for DDL Tools to use?

Author  Topic 

JozzaTheWick
Starting Member

16 Posts

Posted - 2003-02-22 : 13:05:47

I'm in the process of creating a database (from the physical data model, created in MS Visio 2000) containing about 30 tables, and am trying to find out how I can keep the model up to date and ensure it reflects changes as they are made in future. I know you can generate Access databases from Visio drawings, but not SQL Server databases, it seems.

Are there any tools (apart from Erwin) that I can use to generate and modify databases using the data model as a source? I want to be able to apply some form of version control (using SourceSafe) to the data model (or DDL scripts).

How have people handled database structure versioning on their systems?

Thanks,

Joseph
   

- Advertisement -