You can estimate the size of your resulting SQL database by identifying the size of your PVData, SMData, and POIVData folder and your Global\master_qxm folder.

Determine the size of your data folders

• PVData folder
• SMData folder (if present)
• POIVData folder (if present)

1. Log into Sage 300 CRE.
2. On the Select Company screen, note the path in the Location column.
3. Go to that directory. The default locations are:
   1. C:\ProgramData\Sage\TIMBERLINE OFFICE\Data from the server
   2. \\[SERVER]\TIMBERLINE OFFICE\Data from a workstation
4. Right-click on the PVData folder, select Properties, and write down the Size shown on the screen.
5. If present, right-click the SMData folder, select Properties, and write down the Size shown on the screen.
6. If present, right-click on the POIVData folder, select Properties, and write down the Size shown on the screen.

Determine the size of the master_qxm folder

1. Browse to the Global folder:
   1. On the server: C:\ProgramData\Sage\TIMBERLINE OFFICE\9.5\Accounting\Global\PVData
   2. From a workstation: Through the Timberline Office shared folder at \\[SERVER]\TIMBERLINE OFFICE\9.5\Accounting\Global
2. Right-click the master_qxm folder, select Properties, and write down the Size shown on the screen.

Estimate the size of the resulting SQL Database

1. Add the size of the SMData, PVData, POIVData folders, and master_qxm folders.
2. Multiply the total size of those Pervasive files (from the prior bullet) by 1.5. This is the estimated size of your SQL data folder after using Sage SQL Replicator.

Important

Microsoft SQL Server Express Edition has a database size limit of 10 GB per database. If the estimated size of the SQL database exceeds that, use SQL Server Standard or Enterprise Edition.