propagate db changes, how to

[chikkodi]

Hi,

I am looking for a way to propagate database changes from the development databases to test databases. Since this happens almost on a daily basis, we want to automate this process.

How would you recommend the OEM Change Management Pack to do the above ? Are there any other tools ?

Thanks for your input

[santoshym]

Hi

You can use Replication

Regards,

[chikkodi]

I am sorry, may be I posted my question wrong.

By database changes, I mean, changes
to database objects like stored procedures, tables, etc.
As and when designers modify stored procs,
they are loaded to dev databases and then periodially
we need to update the test dataabses with all the changes
that had been done since the last update

[chikkodi]

Could you please provide your expert advice ?

[tamilselvan]

Use SourceSafe or PVCS. In which check in delta changes to tables as a text file and later check out those files and apply to test environment.
The date and time should be appended to the file name, example ddl_20010722_1500.sql. The next file is ddl_20010722_1530.sql and so on ......

[santoshym]

Hi

You can use Rational clearcase too which is a Version control software.You can check for more info on there site

http://www.rational.com

Regards

[chikkodi]

Thanks for your input

We have all our stuff in clearcase. Now, I have to manually update all the various dataases
from clearcase, whenever any change happens. I was wondering if there is a tool to do this.

Thanks again