wavesmash (6/27/2008)
So there is no way to automatically sync table schema or stored proc schema changes during replication without using a 3rd-party tool?With database mirroring, is a shared drive (SAN) a requirement?
thanks,
Andrew
not a replication expert, those sort of changes need to be done by replication stored procedures provided for the purpose (or via gui) I believe, so require manual amendments to replication set up when changes are made.
Mirroring does not care whether databases are on local disks or SAN, as long as the servers can communicate.
---------------------------------------------------------------------