replicating MS Great Plains database

Hi, I hope comeone could help with an additional query i have.
I submitted a post just previously asking how I can configure replication in
the situation where I have a database (call it db1) and a copy of db1 (call
it db2). db2 was created via:
1. detach db1
2. make a copy of db1 (call it db2)
3. attach db2 to new server
Replication is set up in such a way so that db1 replicated to db2 (via
transactional - or whatever is best) and after a few days db2 becomes the
new replacement for db1.
My query is, will this work if db1 is a great plains database? I know great
plains uses a number of databases for its configuration.
How should i set this up? Any help most appreciated!
Cheers,
Jen
That's a difficult question to answer. Some application will write server
specific information to the database and it will be difficult to have the
application use the replicated database.
I would test to see if the application is sensitive to the copied database
first.
For disaster recovery solutions similar to what you are describing
replication is not the best option as it does not do automatic failover. Log
Shipping is the best solution as every object is copied, even system
objects.
If you must use replication for this you have to
1) make sure every table has a PK
2) make sure all constraints, triggers and identity columns are marked not
for replication
3) make sure you use different identity seeds on each side (odd on one side
even on the other) and use an increment of 2
4) use DBCC checkident(tablename, reseed, #) on each side on the identity
tables to make sure that the tables with odd seed will all have odd values
for their current or next value, and make sure all tables on the other side
with the even seed will all have even values for their current or next
value.
Hilary Cotter
Looking for a SQL Server replication book?
http://www.nwsu.com/0974973602.html
Looking for a FAQ on Indexing Services/SQL FTS
http://www.indexserverfaq.com
"jen" <jc@.nospam> wrote in message
news:OnlBhSw$FHA.3096@.tk2msftngp13.phx.gbl...
> Hi, I hope comeone could help with an additional query i have.
> I submitted a post just previously asking how I can configure replication
> in the situation where I have a database (call it db1) and a copy of db1
> (call it db2). db2 was created via:
> 1. detach db1
> 2. make a copy of db1 (call it db2)
> 3. attach db2 to new server
> Replication is set up in such a way so that db1 replicated to db2 (via
> transactional - or whatever is best) and after a few days db2 becomes the
> new replacement for db1.
> My query is, will this work if db1 is a great plains database? I know
> great plains uses a number of databases for its configuration.
> How should i set this up? Any help most appreciated!
> Cheers,
> Jen
>