Test db to Production db

[sunnydd]

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.

[AJones]

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.

[nbohne]

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

[sunnydd]

Thanks very much for your responses.