Linking Databases
I took it that she has 15 datafiles and each is set to the maximum size, she seemed to not know about segments. Maybe I took it wrong. I have used multiple datafilee in one program, and then had to segment out some of them…that’s where I am coming from. Yes, upon checking she says segments which then puzzles me as it should be much more than 3.75 gigs. Oh well, I lose again. I really should not try to answer questions.
> On Mar 1, 2018, at 1:18 PM, Michael Mantkowski <michaelj@clientrax.com> wrote:
>
> 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
_____________________________________________________________
Manage your list subscriptions at lists.omnis-dev.com
Start a new message -> mailto:omnisdev-en@lists.omnis-dev.com