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.
| Author |
Topic |
|
AskSQLTeam
Ask SQLTeam Question
0 Posts |
 Posted - 2006-02-27 : 12:05:33
|
| Radu writes "Hello,I'm would like to know if exist a posibility, a tool or something that allows me to keep tracking of a ms sql database objects (tables, stored procedures, user functions, views) versions. I would like also to know or label these object's version. If it's possible also to generate auto the patches to transform an object (old version let's say 1.0) into the same object (new version let's say 1.1).Thanks Radu" |
|
|
activecrypt
Posting Yak Master
165 Posts |
Posted - 2006-02-28 : 01:08:58
|
| Hi,would you please brief your question more precisely , its unclear to me . what you wants to acheive ?!Andy DavisSql Shield Team--------------------------------------------SQL Server Encryption Softwarehttp://www.sql-shield.com |
 |
|
|
Radu
Starting Member
1 Post |
Posted - 2006-02-28 : 03:45:51
|
| For example I want to release my product now version 1.1.0After 1 months I want to release the version 1.1.1. Of course several database objects (tables, functions, stored procedures, views) will suffer some changes. I want to keep tracking of changes btw versions and generate a database patch (sql script file) that will convert my database version 1.1.0 into 1.1.1. I would like if it's possibile to have this patch file (sql script file) generated automatically somehow. I know that all the operations vs database file are kept in log file but how can I get it from there....?I hope that my problem becomes clearer now. Maybe dotNet 1.1 or 2.0 has something implemented for ms sql 2000 |
|
|
|
schuhtl
Posting Yak Master
102 Posts |
Posted - 2006-02-28 : 11:16:07
|
| Try looking at Red Gate's SQL Compare tool. There are several tools out there that do the exact same thing but I have never used them. We use SQL Compare at my company to script the differences between our DEV and QC and QC and PROD environments and I have no complaints. It compares the objects in the two databases and you choose which object(s) you want to script. It is very easy and you can create a rollback script at the same time just in case you need it. I then take my new script and my rollback script and check them into Source Safe. |
|
|
|
activecrypt
Posting Yak Master
165 Posts |
Posted - 2006-02-28 : 23:14:20
|
| Hi,true said and for you convience you may give objectname suffix with your build version also. so that you can easily identify the version ,to dig through the LOG File you may refer the software as suggested.Andy DavisSql Shield Team--------------------------------------------SQL Server Encryption Softwarehttp://www.sql-shield.com |
|
|
|
|
|
|
|
|
ms sql 2000 database objects versions