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 - 2002-12-19 : 09:28:17
|
| Harold writes "HelloIm building an application, and I already have versions of this application.For a a cliente, wich have version 1.0 I need to run every script to update his database to match the one Im using for the verion 1.5.If I keep realising versions, I will need a tool to keep track of every change to my database, for every client using every version of my application.Is there tool to make this easy??Im thinking to create a table with a correlative number, and build every sript updating that correlative number. So I will know wich script was executed on every client...Is this factible???Thank you very muchHarold" |
|
|
nr
SQLTeam MVY
12543 Posts |
Posted - 2002-12-19 : 10:35:19
|
| Just put an UpdateHistory table on the client.Allocate each scrip an ID and in the script insert it into this table.Then your script can interrogate the table to see if it is allowed to run on that version.To compare databases you could get a copy of sql compare adverised on this site or just write a script to do the compare yourself.==========================================Cursors are useful if you don't know sql.DTS can be used in a similar way.Beer is not cold and it isn't fizzy. |
 |
|
|
|
|
|
script control