Hi,
I'm trying to copy a database from our production environment to our test. Currently the production server is performing replication. What is the best method to setup replication on our test server. We are using SQL 7.0
I moved the prod database over. Should I moved the replicated database too or do I just create the replicated database from scratch.
Is there a way to import the replication properties over from prod to test?
Just need advice on best practices. Also looking for advice because we will be making changes to our database how would I maintain the replication or would I have to recreate the replication properties after we make our database changes? Sounds confusing. Thanks for the help.
I'm trying to copy a database from our production environment to our test. Currently the production server is performing replication. What is the best method to setup replication on our test server. We are using SQL 7.0
I moved the prod database over. Should I moved the replicated database too or do I just create the replicated database from scratch.
Is there a way to import the replication properties over from prod to test?
Just need advice on best practices. Also looking for advice because we will be making changes to our database how would I maintain the replication or would I have to recreate the replication properties after we make our database changes? Sounds confusing. Thanks for the help.