gINT Pro with SQL Express

It works with Express, but 10 GB database size is not enough for most production environments.

Thanks Phil - it's possibly just for testing purposes at the moment.

What's the workflow with Pro Plus?  The documentation isn't massively clear.  It seems to suggest that "Data is entered and edited in a single project (.GPJ) files and then moved to the SQL server database."

From the manual it seems that you:

• Enter and edit data in the .gpj file
• Once complete Upsize the .gpj file to the Enterprise database
• First project uploaded determines the structure of said Enterprise database
• Data is reported on from the Enterprise database
• Other .gpj files can be upsized to the same database as long as it has a unique identifier and the structure and library is the same.
• If you want to update a gINT project in Enterprise, you make the changes in the .gpj file and then Upsize Current Project to Enterprise - effectively replacing the project that is in the Enterprise database.

So can editing of the projects in the Enterprise database be done?  The manual implies that it can be viewed and reported on, but does not mention editing.

I also take it that if you have projects that have differing structures and libraries, then each one would have to be stored in it's own Enterprise Database?

You can use the SQL Server in two ways

1. You do the day to day work in a gpj, and import gpjs to the sql server at the end of the project, so the sql server is an archive.

2. You do day to day work in SQL Server, so never use gpjs.  Yes you can make new ProjectIDs, enter and edit data in SQL Server.

I also found the GPP doc a bit light on, and have written documentation for my clients.

Best to convert/translate gpjs to one structure.  Having multiple SQL Server databases defeats the purpose.

Thanks Phil

Thanks Phil