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.
| Author |
Topic |
|
vadood
Starting Member
7 Posts |
 Posted - 2003-05-18 : 09:18:28
|
| Hi,I tried to create a merge replication using T-SQL. Everything seems to work ok and and replication is being done. But no copy of the initial data in publication database is copied to the subscription database.I have possibly forgot something, but do not know what! But a snapshot agent is created and it reports successful creation of the initial snapshot.vadood |
|
|
DavidD
Yak Posting Veteran
73 Posts |
Posted - 2003-05-20 : 00:10:25
|
| Did you tick "Subscriber already has the schema" or something like that? There is that option in the creation of the subscription which allows you to decide whether or not to create your database from the snapshot or just use a database you already have. Also remember a snapshot can take a while to be created. It is better to wait until it has finished brfore you create your suscription. |
 |
|
|
vadood
Starting Member
7 Posts |
Posted - 2003-05-20 : 00:19:29
|
| the snapshot agent reports "Snapshot of 1 article created successfully". for the "Subscriber already has the schema", I am creating the replication using T-SQL system stored procedures in query analyzer, so I did not tick anything. I also do not know which parameter of those system stored procedures is related to this?any hint? |
|
|
|
|
|
|
Merge replication and initial snapshot