We have a SQL SERVER 2005 with 700 databases running.
Our idea is to replicate all the databases on the server with the SQL SERVER Replication Services (http://msdn.microsoft.com/en-gb/library/ms151314(SQL.90).aspx) to get two identical data servers running at the same time.
We've achieved to publicate a single database and subscribe this database in other SQL SERVER but our problem resides in that we can't publicate all the databases at the same time in a single publication (we can register any database in a single publication and subscribe this publication in the other server manually but we don't want to do every time which a database is created or eliminated).
How can i publicate and subscribe all the databases automatically between the two servers?