.Net Stored Procedures & Replication

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)

.Net Stored Procedures & Replication

Author

Topic

BRingerOD
Starting Member

1 Post

Posted - 2007-10-25 : 20:49:44

.Net Stored Procedures & Replication

Can you do it? I have some transformation and business logic I need to place in the transactional replication process.

Just curious if its possible.

BTW, I know I should not be doing transformation during transactional replication. At the moment the client wants realtime updates to a central repository thought transactional replication.

Thanks in advance!

Bryan

tkizer
Almighty SQL Goddess

38200 Posts

Posted - 2007-10-25 : 21:57:21

Yes this is possible. By default, replication uses stored procedures to insert/update/delete the data at the subscriber. You can easily modify these stored procedures and include .NET stored procedures.

In 2005, the stored procedure names are like this:
sp_MS<dmlShort>_<objectOwner><objectName>

For example:
sp_MSdel_dboTable1
sp_MSins_dboTable1
sp_MSupd_dboTable1

In 2000, the stored procedure names are like this:
sp_MS<dmlShort>_<objectName>

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

Subscribe to SQLTeam.com

SQLTeam.com Articles via RSS

SQLTeam.com Weblog via RSS

- Advertisement -

Resources