Share
ReportWHere can I find a GP sample database?
*This post is locked for comments
You’re offline. This is a read only version of the page.
WHere can I find a GP sample database?
*This post is locked for comments
GPguy,
The sample company gets installed with the core install of GP. To create (or recreate) it, you need to log into GP Utilities as 'sa'.
I don't think there is any way to do this unless you can find another install and get a SQL backup of the TWO (that's always what is used for the sample company) database from it.
I don't think the Microsoft licensing agreements allow us to just send this to someone, sorry. If you are a current GP customer, you can get this from your GP partner. Also, you're talking about a 380MB database here, even zipped, doubtful that you can do this over e-mail.
Here is a link to the GL tables page on my blog: http://victoriayudin.com/gp-reports/gl-tables/ for future reference and additional information.
If you're looking for all posted transactions you'll need to union GL20000 and GL30000.
I am new to GP, and loaded the demo for first time, then will get MSDN licence and want to do contract work. Just getting the hang of this forum ... .
For the TWO database, you could download the demo. Since you have a license, you should have rights to this. The file is GP10.0Trial.exe (1.68 gb) and unzip the whole thing to a folder you create (2.42 gb, 508 files) (but don't continue with install). In there you will find two files: GPSTWODat.mdf (317 mb) and GPSTWOLog.ldf (122 mb). I believe you can then load this with SQL Server but you need to get the how to from an MS SQL Server techy which I am not there yet). I did notice on my install that these flashed by when they were being loaded.
The link for demo download is here:
http://www.microsoft.com/downloads/details.aspx?FamilyID=01fb6157-0a4d-407a-afe0-de03af95c6b6&DisplayLang=en
My advice: do all this experimentaton on a totally separate stand-alone machine - not your production environment. Too risky to monkey with SQL back-door tricks etc with prod.
Cheers, Dave
All responses (
Answers (
