January 31, 2011 at 10:34 am
michael.morse (1/31/2011)
When I do a manual sync of the data I am using import/export wizard to do this is this ok or should I be doing it a different way?
That should be fine.
David
@SQLTentmaker“He is no fool who gives what he cannot keep to gain that which he cannot lose” - Jim Elliot
January 31, 2011 at 10:38 am
Yeah I added the subscriptions. There is a checkbox when setting up the publication that says 'create stored procedures during initial synchronization of subscriptions' I unchecked that box since I wasnt going to be initializing the subscription
January 31, 2011 at 10:49 am
Okay I think I found the answer to my original question
The same place where you can specify the stored procedures to use instead of the original commands there is a check box where if you dont include special stored procedures you can tell it to use column names instead, I will be testing to make sure this is correct.
January 31, 2011 at 11:31 am
Great. Let me know how this works.
David
@SQLTentmaker“He is no fool who gives what he cannot keep to gain that which he cannot lose” - Jim Elliot
January 31, 2011 at 11:41 am
So far it seems this is the way to go
Setup the publication with the option to use column names and use the export wizard to initialize the data by mapping the columns
Setup the subscription to skip initializing
I tested a few inserts and deletes with one of the offending tables and it seems to be able to keep up and replicate the changes no problem. I am going to be trying this again with the whole publication and I will post an update of how it goes.
This website is great for finding the help you need when you are stuck. Thank you for you help.
January 31, 2011 at 11:55 am
michael.morse (1/31/2011)
This website is great for finding the help you need when you are stuck. Thank you for you help.
Completely agree. I know I look here before anywhere else typically.
Glad to help too.
David
@SQLTentmaker“He is no fool who gives what he cannot keep to gain that which he cannot lose” - Jim Elliot
Viewing 6 posts - 46 through 50 (of 50 total)
You must be logged in to reply to this topic. Login to reply