Database Migration

[mistermudd]

Hello all,

I have been testing TimeTrex for use with the company I am employed with and we have decided to go ahead and install TimeTrex on our Windows 2003 server.

While testing, I went ahead and set up TimeTrex with our company information, recurring schedules that we actually use, and other info. When I install on the server, I would like to migrate the database from my existing install for convinience.

Basically my question is this:

How would I accomplish this? What do I need to copy over, and where do I need to copy it to after I install on the server.

[shaunw]

If you are not familiar with SQL dumps, this can be a tricky process, I would recommend purchasing our installation support package so we can assist you in the transfer of data and make sure everything is working correctly.

Basically you need to install the exact same version of TimeTrex on your new server, and run a SQL dump on your current TimeTrex server to extract the data from its database, then do a SQL import into a empty database on your new server.

[mistermudd]

Thanks for the info.