About replication

Hi :
If I want to do the follow :
I create 2 database in localhost
one is dev_db
one is clone_db
Where dev_db have data in the database, but clone_db is just a data
structure but need to synchronize with dev_db schema.
If I add table in dev_db , clone_db will auto add same table structure from
dev_db.
If I change the column (include add, change data type), clone_db will auto
to change.
If I change the script (both view, stored procedure, view, user define
function and trigger), , clone_db will auto to change.
Base on above situation, can replication do this ?
and how to set ?
Thanks for your help
Tom,
there is a DTS 'Copy Objects task' which allows you to copy the schema
without taking the data. There are also tools (Redgate) which'll allow
similar things. To have this automatic is not possible AFAIK using SQL
Server 2000. In SQL 2005 there are ddl triggers that we could take advantage
of, but in SQL 2000 you'd have to have some sort of proactive polling
solution.
HTH,
Paul Ibison SQL Server MVP, www.replicationanswers.com
(recommended sql server 2000 replication book:
http://www.nwsu.com/0974973602p.html)