Linking Databases

Michael Mantkowski, March 01 2018 16:18:10

Hi Das,

According to original email all 15 segments are already used up.

I am not aware of any way to go beyond that accept the method I discussed. I would be happy to be wrong about that.

*********************************************************************
Michael Mantkowski
ClienTrax Software
1-614-875-2245
*********************************************************************

—–Original Message—–
From: omnisdev-en [mailto:omnisdev-en-bounces@lists.omnis-dev.com] On Behalf Of Das Goravani
Sent: Thursday, March 1, 2018 4:13 PM
To: OmnisDev List – English <omnisdev-en@lists.omnis-dev.com>
Subject: Re: Linking Databases

No Michael she can have segments and keep on going seamlessly She doesn’t have to move the data, segments are the way to go. I didn’t read that she’s exhausted all of the segments possible, maybe I missed that.

> On Mar 1, 2018, at 1:06 PM, Michael Mantkowski <michaelj@clientrax.com> wrote:
>
> Jeanne,
>
> I believe the only thing you can do (besides going to SQL) is to open
> more than one data file. You can then offload some of your data to
> use that file instead of the main data set.
>
> For instance, you could offload all your Line Item Transactions or
> General Ledger Entries to this file freeing up space in the Main Data.
>
> You would then use the Set current data file {DataName} command to
> move between the two. You will want to simplify the data access as
> much as possible so that you do not end up with data in both files.
>
> *********************************************************************
> Michael Mantkowski
> ClienTrax Software
> 1-614-875-2245
> *********************************************************************
>
>
> —–Original Message—–
> From: omnisdev-en [mailto:omnisdev-en-bounces@lists.omnis-dev.com] On
> Behalf Of Jeanne Reyes
> Sent: Thursday, March 1, 2018 3:25 PM
> To: omnisdev-en@lists.omnis-dev.com
> Subject: Linking Databases
>
> I have a native studio database with 15 fully expanded segments
> totalizing
> (3.75 gb). My understanding is that Studio can handle up to 1
> terabyte of data, but with only one database is not possible. I think
> I remember that there is a way to link databases together.
>
> I’m running out of space and can not close the older data until a
> couple of years form now. How can I have several datafiles, but still
> have them treated as one for the purpose of reporting and historical
> data? and no, I cant use SQL (tried, failed, my try again in the
> future)
>
> Thanks,
>
> Jeanne Reyes
>
> —
> Shop online through
> this link to help me pay for college!
> _____________________________________________________________
> Manage your list subscriptions at lists.omnis-dev.com Start a
> new message -> mailto:omnisdev-en@lists.omnis-dev.com
>
> _____________________________________________________________
> Manage your list subscriptions at lists.omnis-dev.com Start a
> new message -> mailto:omnisdev-en@lists.omnis-dev.com
>

_____________________________________________________________
Manage your list subscriptions at lists.omnis-dev.com Start a new message -> mailto:omnisdev-en@lists.omnis-dev.com

_____________________________________________________________
Manage your list subscriptions at lists.omnis-dev.com
Start a new message -> mailto:omnisdev-en@lists.omnis-dev.com

Linking Databases