In short, you will need to install SQL Server and Macola on the development machine, you cannot simply copy the macsql folder to do this. Documents on how to install Macola are located on the CDs. You will likely need to update Macola to whatever version you are on, it is very likely you are not on 7.7 but 7.7.something else.

There is a document on the customer portal on installing SQL Server, but I rarely use it. The only real "gotcha" is be sure to install it as mixed mode authentication.

Is there something specific you are having an issue with?

Software Training, Implementation, Programming and Support for Macola Progression, Macola ES, Synergy, and Crystal Reports. Check out our Macola tools: www.gainfocus.biz/exceladdin.html

We are on 7.7.700 in production on a separate Macola App Server and Data on a Separate SQL Server. What I was hoping to do is install Macola on a Test App Server and restore the Production Macola data to a test SQL server. Then copy the production Macola App Server folders over the newly installed Macola Test App folders, (IF I need to?).
The I know I have to change drive mappings locations in the compfil. I am wondering what else I need to change. Would like to end up with my current production environment in a test environment to run code changes against, before moving to production.
Just wondering the best method to go about this.

Don't copy the folders, install Macola brand new. The installation registers a lot of dlls and what not on the app server so copying the folders won't cut it. The Macola installation directions are on the CDs. Do you have CDs or iso images of the CDs?

Software Training, Implementation, Programming and Support for Macola Progression, Macola ES, Synergy, and Crystal Reports. Check out our Macola tools: www.gainfocus.biz/exceladdin.html

I was able to accomplish this by newly installing Macola on the new test Application server from the new test SQL server. Creating a new mapped drive to the Test App Server macsql directory. Copying over the Test macsql directory with the prod macsql directory. Restoring the Production data, Screen, PWE, to the Test SQL server. Change the macsql.cfg, ProSql7.cfg, and pwe.tam files to point to the test SQL server. Change the drive letter mapping in the compfil_sql to point to the new test App server. Reset the Supervisor password per the instruction found on Exacts site and resynch the users in SQL via Macola Tools.