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 |
|
makimark
Starting Member
34 Posts |
 Posted - 2003-10-05 : 04:28:37
|
| HiWhat would be the best replication model for an app without Primary keys in the database design ? Merge, Transactional ? We have tried to do log shipping - log is too big though. The application, if anyone wonders, is Microsoft Great Plains.thanksMark |
|
|
tkizer
Almighty SQL Goddess
38200 Posts |
Posted - 2003-10-06 : 12:40:57
|
| Log shipping is not the same as replication. It is for disaster recovery only.We would need more information in order to be able to assist you. Although I don't think that you can use any kind of replication without primary keys on your tables.Which begs the question, why don't you have primary keys? Someone once said about database design, if you don't have a primary key, you don't have a table.Tara |
 |
|
|
|
|
|
Replication