Tell me more ×
Database Administrators Stack Exchange is a question and answer site for database professionals who wish to improve their database skills and learn from others in the community. It's 100% free, no registration required.
up vote 3 down vote favorite

I have SQL Server 2000 as publisher and SQL Server 20008 R2 as subscriber.

I want to replicate data from SQL Server 2000 to SQL Server 2008 R2 on a different machine.

Primary key fields are not defined on some tables so transaction replication is not a choice.

I think merge replication is not a choice because the Subscriber SQL Server version is higher than the publisher.

What can I do?

share|improve this question
2  
Can you not add primary keys to those tables which are missing them? – Damien_The_Unbeliever Feb 7 at 8:19
I just can add an identifier filed and set it as primary key. Will this solve my problem for transactional replication? – Raymond Morphy Feb 7 at 8:28
1  
Well, you need primary keys on all tables for any replication to work. Otherwise how are you going to know which rows have been moved over to the subscriber or not? – Marian Feb 7 at 10:03
3  
May I ask what the business problem that you are trying to solve is here? I'm curious to know why Replication has been chosen as the solution implementation method over other available options, which could be more suitable. – John Sansom Feb 7 at 14:15
I want to have an updated version of SQL Server2000 which is filled by windows applications in SQL server 2008 and use it in my website. because I have used some features of SQL server 2008 in my web site.I just can add add identity fields as primary key in tables.is this solve my problem? – Raymond Morphy Feb 8 at 21:03

migrated from stackoverflow.com Feb 7 at 8:54

Know someone who can answer? Share a link to this question via email, Google+, Twitter, or Facebook.

Your Answer

 
discard

By posting your answer, you agree to the privacy policy and terms of service.

Browse other questions tagged or ask your own question.