Similar to this situation, we need to replicate only the database structure from one SQL Server to another SQL Server (v2005).

How could this be achieved across 2 sql servers having direct connectivity between them.

The reason to have such a arrangement is that the production db structure keeps changing and we need to replicate everything as part of one of our deliverables.

So, we are hoping to carry on this db structure activity on staging server and timely replicating the db structure on another server (maybe a staging server) to keep it in sync.

Please Help.

Thanks.