×
INTELLIGENT WORK FORUMS
FOR COMPUTER PROFESSIONALS

Contact US

Log In

Come Join Us!

Are you a
Computer / IT professional?
Join Tek-Tips Forums!
  • Talk With Other Members
  • Be Notified Of Responses
    To Your Posts
  • Keyword Search
  • One-Click Access To Your
    Favorite Forums
  • Automated Signatures
    On Your Posts
  • Best Of All, It's Free!

*Tek-Tips's functionality depends on members receiving e-mail. By joining you are opting in to receive e-mail.

Posting Guidelines

Promoting, selling, recruiting, coursework and thesis posting is forbidden.

Students Click Here

Need Set Up Instuctions Progression SQL Dev/Test Enviroment on Seprate Server

Need Set Up Instuctions Progression SQL Dev/Test Enviroment on Seprate Server

Need Set Up Instuctions Progression SQL Dev/Test Enviroment on Seprate Server

(OP)
We are doing some heavy development with Wisys and Macola 7.7 and need to set up a different Progression and SQL environment that will not affect production.

I have both a separate Dev Macola server and Dev SQL server available. Would like to restore production data to this Dev SQL Server and run my testing against the preproduction environment.

What do I need to do to accomplish this?

RE: Need Set Up Instuctions Progression SQL Dev/Test Enviroment on Seprate Server

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

RE: Need Set Up Instuctions Progression SQL Dev/Test Enviroment on Seprate Server

(OP)
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.

RE: Need Set Up Instuctions Progression SQL Dev/Test Enviroment on Seprate Server

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

RE: Need Set Up Instuctions Progression SQL Dev/Test Enviroment on Seprate Server

(OP)
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.

Red Flag This Post

Please let us know here why this post is inappropriate. Reasons such as off-topic, duplicates, flames, illegal, vulgar, or students posting their homework.

Red Flag Submitted

Thank you for helping keep Tek-Tips Forums free from inappropriate posts.
The Tek-Tips staff will check this out and take appropriate action.

Reply To This Thread

Posting in the Tek-Tips forums is a member-only feature.

Click Here to join Tek-Tips and talk with other members! Already a Member? Login

Close Box

Join Tek-Tips® Today!

Join your peers on the Internet's largest technical computer professional community.
It's easy to join and it's free.

Here's Why Members Love Tek-Tips Forums:

Register now while it's still free!

Already a member? Close this window and log in.

Join Us             Close