Unanswered: How to manage the version of Tables,View, and so on
I am managing the SQL script files for constructing tables,views,and so on with Visual Source Sefe.
But once I run these scripts with a tool like Query Analyzer
for the database in SQL Server,
I do not know How to get the versions of the scripts which were installed now, with using Enterprise Manager or any tool associated with SQL Server2000.
Please tell me How are you managing and
know which version of scripts have been installed on database in SQL Server.
Thanks for Reply.
I want to manage the scripts for tables,views,etc, and I think it is possible with using Visual Source Safe(VSS) from view of source code level.
Using VSS, each scripts are version controled, as you know,
like this for example:
--------- T_Person.sql --------------
version 1 new created
version 2 null problem bug fix
In my developer team, if scripts in VSS are edited and updated,
the most new scripts are applied to the database that we use for develop
(with Query Analyzer).
And now, we think there is a problem.
We can controll the source code's version with VSS,
but there is one question "which script version in VSS Is this database using?"
I wish there is someone who had the problem similer to us and solved it.
I wish I would tell you what I mean as I think in Japanese exactly.
Sorry for my poor English.
Basically, if I understand correctly, you are looking at adding something to the scripts so you can look at a somewhere and go "ah, table SystemUser was created using version 5 of the table creation script"....
With stored proces and the like I have seen other people do this by adding headers or footers to the stored procedure that hold comments regarding what version of the script is being used.
With tables you are a bit stuck though.... unless in each table creation script you include a line that does an insert into a system table to say what script was used to create the table....