Just to confirm, do identity columns and XML columns work OK with database mirroring ? That is, all data types are supported with mirroring, and identities aren't an issue ?
Transactional replication with identity columns was a right pain in the **** in SQL 2000. I'm assuming that mirroring doesn't have these issues, but want to be sure.
Hi Andrew. Yes, mirroring supports and works seamlessly with identity columns and XML columns, as well as many other built-in database functionality in SQL 2005 (full text search for example, et al.). Mirroring is really more similar to real-time log shipping than replication, they use totally different technologies and methods for duplicating data.
HTH,
No comments:
Post a Comment