Community
Showing results for 
Search instead for 
Do you mean 
Reply

Test db to Production db

Tuned Listener
Posts: 113
Country: USA

Test db to Production db

I am in the process of setting up a new ACT implementation.  Is there a way to have a test database set up and then migrate only the database structure to the new database?  Or do I have to manually remove all of the test data and then copy the database to production?
 
Thanks.
Nickel Super Contributor
Posts: 584
Country: USA

Re: Test db to Production db

Hi Sunny,

You can save an empty copy of the test database. That will give you just the structure without the data.

To do this, go to File / Save Copy As and select Empty Copy.
Copper Elite Contributor
Posts: 95
Country: USA

Re: Test db to Production db

Be aware that any custom content such as reports won't be copied when do you save copy as, you have to manually move the files over from the (databasename)-supplemental files folder to the new database
Nick Bohne
Effective Solutions, Inc.
Tuned Listener
Posts: 113
Country: USA

Re: Test db to Production db

Thanks very much for your responses.