When I do transactional replication and use the option for "Initialize the Schema and Data", the keys do not get replicated to the subscriber.
If I do not use the "Intialize the Schema and Data" but rather backup and restore the DB to the Subscriber and select the option for "DB already has Schema and Data", When there is a change to any data I will get an error that "sp_msins(table) not found in (database)" ("table" is the table where the change was made in the publisher, "database" is the subscriber database).
Anyone have any idea why the keys are not getting replicated? Or if they for some reason aren't supposed to replicate, any idea on how to resolve the second issue I encounteded for my work around?
Thanks
If I do not use the "Intialize the Schema and Data" but rather backup and restore the DB to the Subscriber and select the option for "DB already has Schema and Data", When there is a change to any data I will get an error that "sp_msins(table) not found in (database)" ("table" is the table where the change was made in the publisher, "database" is the subscriber database).
Anyone have any idea why the keys are not getting replicated? Or if they for some reason aren't supposed to replicate, any idea on how to resolve the second issue I encounteded for my work around?
Thanks