Showing posts with label steps. Show all posts
Showing posts with label steps. Show all posts

Wednesday, March 21, 2012

Need Clarification - merge replication

Hi,
I need to add new tables to merge replication.
These are the steps I have followed,
1. Executed the table script both in Publisher & Subscriber
2. Add 'rowguid' column in that table (Publisher & Subscriber)
3. In publication properties-->Articles, included the new table and
snapshot was automatically started.
(a) Is it the correct way to add tables to merge replication or is there any
better way?
(b) Should I stop the merge agent during this process?
Please advise.
Thanks,
Soura.
Soura,
unless you're doing a nosync initialization, it is normal to add the
articles to the publication, run the snapshot agent then the merge agent. A
full snapshot is created, but only the new article will get propagated.
There's no need to deal with the guid column - it'll get created for you if
a guid (rowguid) isn't there.
Cheers,
Paul Ibison SQL Server MVP, www.replicationanswers.com
(recommended sql server 2000 replication book:
http://www.nwsu.com/0974973602p.html)

Need basic.

Hi All,

Can this be done and if so can you give a bullet list of the steps need to accomplish this.

I need to load a bunch of files into a stagging table. Need to loop through the files and load them.

Thanks,

Michael

Essentially you're looking at is the following:

1) A for each container using the for each file enumerator.

2) Within that, you'll need to assign the filepath to a variable

3) Within the container, create a dataflow task with a flatfile source and a sql server destination, mapping the columns.

4) dynamically change the connection string of the flatfile source (properties/expression)

Hope this helps

|||

Thanks Rick,

That is a good start, I will see how far I can get.

Michael