Viewing 15 posts - 1 through 15 (of 32 total)
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...
January 31, 2011 at 11:41 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...
January 31, 2011 at 10:49 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...
January 31, 2011 at 10:38 am
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?
January 31, 2011 at 10:33 am
So what your saying is supposedly i should just need to do the steps below and it should be ready to go?
1. Create the publications (renaming the stored procedures...
January 31, 2011 at 10:32 am
Oh in response to your question I mean edit the field order in the stored procedures. I know where to edit the names.
January 31, 2011 at 10:16 am
It seems that I cannot edit them if SQL doesnt initialize the subscription (which it fails because the columns/fields are in different orders). I dont know how to reorder...
January 31, 2011 at 10:13 am
Its seems the data must be initialized first in order to get the stored procedures copied to the subscription database. Where can I edit them before this?
January 31, 2011 at 10:08 am
sjimmo (1/29/2011)
January 31, 2011 at 8:22 am
If I have to special map the inserts updates and deletes how does the snapshot initialize the data? Will it go into the correct fields?
January 28, 2011 at 3:51 pm
I have the test enviroment setup and thats what I have been playing around with.
How do I get the initial data there if I dont initialize?
January 28, 2011 at 3:39 pm
I did see where it references the stored procedures it uses for the tables. Do I create additional stored procedures for each table and reference the new stored procedure...
January 28, 2011 at 3:25 pm
sjimmo (1/28/2011)
This is why it is going to be a nightmare to maintain.Please provide the schema's for the published databases and the schema for the subscriber.
What schema information do you...
January 28, 2011 at 3:22 pm
I believe they are planning on updating the tables at the subscriber but those updates dont have to go anywhere. This is in preparation of removing 4 sql 2000...
January 28, 2011 at 3:20 pm
Can you modify records in a view which in turn would update the tables?
January 28, 2011 at 3:10 pm
Viewing 15 posts - 1 through 15 (of 32 total)