快照事务复制，可以用代码实现吗？

guangfakeji 2011-05-16 09:11:48

如题。在MS SqlServer中进行数据库之间的快照事务复制时，能不能不用企业管理器，而是用sql语句直接生成？

...全文

85 8 打赏收藏转发到动态举报

写回复

用AI写文章

8 条回复

切换为时间正序

请发表友善的回复…

发表回复

guangfakeji 2011-05-18

打赏
举报

[Quote=引用 5 楼 ubuntu_fedora 的回复:]
try this book,Microsoft® SQL Server™ 2000 Unleashed, Second Edition.

you can take a look at scripting replication in chapter 22.
[/Quote]
Thanks!

--小F-- 2011-05-16

打赏
举报

没有见到过只用代码的快照复制

Ubuntu_Fedora 2011-05-16

打赏
举报

definitely yes,

ref book:

Pro SQL Server 2008 Replication

Chapter 5
Configuring Snapshot Replication Using T-SQL

dearbinge 2011-05-16

打赏
举报

[Quote=引用 4 楼 guangfakeji 的回复:]

引用 2 楼 ubuntu_fedora 的回复:
definitely yes,

ref book:

Pro SQL Server 2008 Replication

Chapter 5
Configuring Snapshot Replication Using T-SQL

Thanks for sharing your knowlege, but I use SQ……
[/Quote]
YOU ENGLISH IS SO GOOD GOOD

billpu 2011-05-16

打赏
举报

什么都可以代码实现,但是那个需要编写很多tsql,而且很多系统存储过程你一辈子都不太可能用到几次...所以

Ubuntu_Fedora 2011-05-16

打赏
举报

try this book,Microsoft® SQL Server™ 2000 Unleashed, Second Edition.

you can take a look at scripting replication in chapter 22.

guangfakeji 2011-05-16

打赏
举报

[Quote=引用 2 楼 ubuntu_fedora 的回复:]
definitely yes,

ref book:

Pro SQL Server 2008 Replication

Chapter 5
Configuring Snapshot Replication Using T-SQL
[/Quote]
Thanks for sharing your knowlege, but I use SQL SERVER 2000, it is lower