Please start any new threads on our new site at https://forums.sqlteam.com. We've got lots of great SQL Server experts to answer whatever question you can come up with.

 All Forums
 SQL Server 2005 Forums
 Replication (2005)
 Replication Question

Author  Topic 

lotek
Starting Member

42 Posts

Posted - 2009-10-16 : 15:24:39
I have a system i want to setup replication on. I want to do transactional replication so it is realtime, but my understanding is that it modifys the table schema and we cant do that. What is the next best option?

Thanks!

tkizer
Almighty SQL Goddess

38200 Posts

Posted - 2009-10-16 : 17:35:17
Transactional replication does not modify the table's schema.

Tara Kizer
Microsoft MVP for Windows Server System - SQL Server
http://weblogs.sqlteam.com/tarad/

Subscribe to my blog

"Let's begin with the premise that everything you've done up until this point is wrong."
Go to Top of Page

russell
Pyro-ma-ni-yak

5072 Posts

Posted - 2009-10-17 : 22:22:43
But it does require that you have a primary key on all replicated tables
Go to Top of Page

SreenivasBora
Posting Yak Master

164 Posts

Posted - 2009-10-21 : 14:42:38
Thats correct.

With Regards
BSR
Go to Top of Page

tkizer
Almighty SQL Goddess

38200 Posts

Posted - 2009-10-21 : 15:04:47
lol

Tara Kizer
Microsoft MVP for Windows Server System - SQL Server
http://weblogs.sqlteam.com/tarad/

Subscribe to my blog

"Let's begin with the premise that everything you've done up until this point is wrong."
Go to Top of Page
   

- Advertisement -