×
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

Split SQL Database across 2 Instances??

Split SQL Database across 2 Instances??

Split SQL Database across 2 Instances??

(OP)
Okay right now I have a Macola installed on my SQL Server with Terminal Services. Users run the app via Terminal Services.

Macola has probably 9 or 10 companies setup, I don't have the exact number off hand.

So the new setup is as follows
I think this part should be fairly simple?
Server 1 Roughly half the companies - SQL/Terminal Services/Macola
Server 2 Other half of companies - SQL/Terminal Services/Macola

Here's my real question
Server 3 - Server containing all companies from both servers.

The trick here is the companies are spread across 2 SQL instances.
That's the way SQL mirroring works so I have no choice.
Can I configure the Macola client to be able to login spread across 2 sql instances?

If not I can just virtualize a second server if I really need to.
Each server would containing a single instance.
 

RE: Split SQL Database across 2 Instances??

Open up your macsql.cfg file, in the macsql folder, it is a text file.  You'll see something like this:

CODE

[SQL_INFO]
Companies_Installed=20
[Company_000]
Name=Macola Electronics
Server=SQL1
Database=Demodata
LOCKDB=MsllockDB
FRL=False
[Company_001]
Name=Gain Focus
Server=SQL1
Database=DATA_001
Lockdb=MSLLockDB
FRL=False
[Company_002]
Name=Exact Software
Server=SQL1
Database=Data_002
LOCKDB=MsllockDB
FRL=False
...

Replace the red SQL1 with whatever SQL Server holds that particular database.

 

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

RE: Split SQL Database across 2 Instances??

(OP)
Great thanks smile

Just to verify one other thing (I manage the server, know very little about Macola)

The logon information is stored within each individual database isn't it?

RE: Split SQL Database across 2 Instances??

No, the usernames, passwords, security (including company and menu restrictions), searches and screens are all stored in one database, the SCREENS database.  Each individual user's Macola desktops are all in another database, the PWE database.

Make sure these databases are in any databasmaintenancece or backup plans you have in place.

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

RE: Split SQL Database across 2 Instances??

(OP)
Sorry to bother you with this.
That makes things a little more challenging.

**The question is on the bottom.
Most of this post is just background I thought would help.

They have a US and a mexico location, right now on a single server.

So my plan so far was to just...
1) Duplicate the current SQL config on two new servers.
2) Delete the appropriate companies within SQL and Macola on each server
3) Install the same version of Macola into the same path as the current server
4) Overwrite it with the Program Files on the current server.

Seemed like a good idea at least...


On the backup server I would have a mirror of each SQL instance.
But now handling a copy of those db's you mentioned from each server gets complicated

=====================

As I was typing I had 2 ideas
1) Is it possible to somehow specify on a per user basis what instance pwe, screens etc... will be read from?

2) If not what about having a second copy of the application directory, configured to use the other instance exclusively?
 

RE: Split SQL Database across 2 Instances??

Item #2 above concerns me:

2) Delete the appropriate companies within SQL and Macola on each server

Please explain your logic with the "and Macola" part.

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

RE: Split SQL Database across 2 Instances??

(OP)
Well on the new Mexico server for example delete
  "xxx300" (Which is not used in MX) in SQL and remove the entry in macsql.cfg

RE: Split SQL Database across 2 Instances??

There is only one application server correct?  If so you cannot remove the entries in Macsql.cfg.  If you do no one will be able to log into that company.

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

RE: Split SQL Database across 2 Instances??

(OP)
Not best practice but they have one physical terminal server, it contains sql and the application.
Nobody has the client on their physical computer.

They want to trash this machine and split it up onto two servers of the same configuration, SQL/Macola Client/Terminal Services.
Each will contain half the companies of the current machine.

RE: Split SQL Database across 2 Instances??

(OP)
Each Macola server will be basically isolated. The user on Server 1 needs no access to Server 2 via Macola.

Think of it has a completely seperate business.

RE: Split SQL Database across 2 Instances??

Without pulling out the agreement, my gut reaction is that you cannot legally do this, it is a violation of the licensing agreement.  I suggest you call Exact or your Exact business partner.

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

RE: Split SQL Database across 2 Instances??

(OP)
I spoke to them about a month ago this is still in the planning and quoting process.

But I used their consultingonce before and it cuts deep into my profits. So I'm just trying to figure it out myself.

RE: Split SQL Database across 2 Instances??

(OP)
Essentially we'll have to buy a second copy of everything with a slight discount (how generous lol). Not cheap but it's not my money.

I understand your view, but thanks for the help thus far. I really appreciate it.

RE: Split SQL Database across 2 Instances??

The 2 instances of Macola do not need to talk to each other right?  As you describe it, just install Macola on the 2nd server.  Not much to it.  If you have users that need access to both instances of Macola just get them a RDC connection to the server.

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

RE: Split SQL Database across 2 Instances??

(OP)
Ok thanks alot, I found a doc on exacts site that seems to explain how to re-add existing companies to a new install of Macola.

So my only other question was about handling two side-by-side macola installtions. Since each instance will include it's own PWE, SCREENS etc... db's.
Can I install to two different directories one configured for each instance?

RE: Split SQL Database across 2 Instances??

Yes you can install in different directories.

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

RE: Split SQL Database across 2 Instances??

(OP)
Ok great.
Thanks for all the help and patience, it's much appreciated!

-Kenny

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