Splitning of native databases.

Hi.

Can someone help me, about hpw to split a big native database.
I have tried to split a big database into 2 or more databases, for many 
years ago, but now I can't remember how.
Can any one help me.

 ----
René 

Hi, Rene,

in addition to the explanation of Henrik, I wish to hint to the fact, that a 
split native database cannot be accessed by the XAL ODBC driver.
For this reason, you have to ensure, that the custmer does not need the ODBC 
driver, before performing the split.

Kind regards 
Hannsjörg Zdarsky
Software Design Engineer
Microsoft Deutschland GmbH


"René" wrote:

> Hi.
> 
> Can someone help me, about hpw to split a big native database.
> I have tried to split a big database into 2 or more databases, for many 
> years ago, but now I can't remember how.
> Can any one help me.
> 
>  ----
> Ren 

Hello René,

The following is from an old Damgaard Technet discussion:

----------------------------------------------------------
RE: DB size

You need to split the database in order to overcome the DOS limitation of 4 
GB. In the Service System FAQ: F-DK-DIAS-LANI-00003 you can find detailed 
information.

Here is an extract.

Fist create a textfile with the name c_data@.dat. Syntax for this is:

path-0  splitno-0   maxsize-0   priority-0
path-1  splitno-1   maxsize-1   priority-1
path-2  splitno-2   maxsize-2   priority-2
:       :           :           :
path-n  splitno-n   maxsize-n   priority-n

There can be up to 15, since it's possible to split into 16 files
Lines starting with ; or # is considered remarks.

path: Path to splitfile x (c_data.xxx, c_data1.xxx, ...)
split-no: Number on "split" (0-15)
maxsize:  "max" size. Is this overruled split 0 is used with out any
other 
split def. considered.
prioritet:  Used as a guideline for priority between splits and the 
extention of the database. Splits with equal priority will be divided 
eaqualy.

Example:

;
; Splitfile definition (c_data@.dat)
;
/disk0      0       100     10
/disk1      1       200     15
/disk2      2       200     15
/disk3      3       100     12

----------------------------------------------------------

In addition
I would like to point out that it is very desirable to do so long before you 
reach 4Gb. In fact it is desirable to keep each of the 16 segments below 2 
Gb as this keeps the RecId's positive. As the ID used to determine the 
segment number is the lowest nibble (4 Bits) of the Recid.

the first parameter in the @ file is the directory followed by the segment 
number follwed by max desired size followed by preference.
The system will total the preference column and if it is f.ex. 200 will do 
xx/200 inserts in a particular file for every 200 inserts until the limit is 
reached when all the limts are reached it will use the first file and fill 
it up and so on.

In recap if you have a DB which will grow large then it is best to plan in 
advance and make the split decision as early as possible and split into lots 
(5+) of files allowing each to grow to 1 Gb each f.ex.

When you get to around 17-22 Gb depending upon the machine configuration you 
get into another problem which is not pretty which basically means you 
should be on another DB !

By the by the official Navision recommendations imply migrating to SQL any 
database larger than 500 Mb !

----------------------------------------------------------

I hope this will help.

-- 
Best Regards
Henrik Hansen [MSFT]
Tecnical Program Manager Microsoft Dynamics C5 & Microsoft XAL
=====================================================
When responding to posts, please "Reply to Group" via
your newsreader so that others may learn and benefit
from your issue.
=====================================================
This posting is provided "AS IS" with no warranties, and confers no
rights.

"René" <rv@systemconnect.dk> wrote in message 
news:DBF55D8B-DBBE-4B87-8340-7C7A15A3EEC9@microsoft.com...
> Hi.
>
> Can someone help me, about hpw to split a big native database.
> I have tried to split a big database into 2 or more databases, for many 
> years ago, but now I can't remember how.
> Can any one help me.
>
> ----
> René