Are there table name changes between version 8 and 10?

[mrstoo]

I'm researching an application that directly connects to GP 8 database and we are considering migrating to GP 10.

Are there significant table structure / name changes between the versions?

Thank you!

 

[winthropdc]

The SDK (Software Development Kit) lists changes made to tables. Usually, table names would not change, but there might be new columns added.

Get the SDK from the Tools folder of CD2 of the install CDs.

David Musgrave [MSFT]
Escalation Engineer - Microsoft Dynamics GP
Microsoft Dynamics Support - Asia Pacific

Microsoft Dynamics (formerly Microsoft Business Solutions)

http://www.microsoft.com/Dynamics

mailtoavid.Musgrave@online.microsoft.com

http://blogs.msdn.com/DevelopingForDynamicsGP

Any views contained within are my personal views and not necessarily Microsoft policy.
This posting is provided "AS IS" with no warranties, and confers no rights.

 

[msndba]

There is a significant difference in table schemas in GP10 vs GP8. It is designed to integrate with Sharepoint and Office 2007, so is very denormalized.

When we upgraded from 9.0 to 10, it took 18 hours to convert the tables and do the upgrade. Our database was 32GB in size, so fair warning there. We were told it would take 7-8 hours by our service provider, then when I attended a GP "seminar" at Microsoft, found out that my experience was not uncommon at all and that some upgrades took even longer.

 

[winthropdc]

I don't know what tables you were touching, but the is very little difference in the core tables other than some new columns.

David Musgrave [MSFT]
Escalation Engineer - Microsoft Dynamics GP
Microsoft Dynamics Support - Asia Pacific

Microsoft Dynamics (formerly Microsoft Business Solutions)

http://www.microsoft.com/Dynamics

mailtoavid.Musgrave@online.microsoft.com

http://blogs.msdn.com/DevelopingForDynamicsGP

Any views contained within are my personal views and not necessarily Microsoft policy.
This posting is provided "AS IS" with no warranties, and confers no rights.

 

[mrstoo]

Thank you both for your comments - I don't have access to the SDK at this time so I can't verify for myself.

At a high level, what tables are considered core and which are not?

And msndba - did you have to make changes to a custom app or did it just take a long time to upgrade your instance?

Thanks again.

 

[winthropdc]

Core tables are tables which have their table definitions in the Dynamics.dic.

Modules: System Manager, RM, PM, IVC, IV, POP, SOP, BOM etc.

As opposed to addon dictionaries such as Project and Field Service.

You can install the SDK from the Tools folder of CD 2 of the install CDs or download it using the links on this blog page:

http://blogs.msdn.com/developingfordynamicsgp/pages/developer-articles.aspx

David Musgrave [MSFT]
Escalation Engineer - Microsoft Dynamics GP
Microsoft Dynamics Support - Asia Pacific

Microsoft Dynamics (formerly Microsoft Business Solutions)

http://www.microsoft.com/Dynamics

mailtoavid.Musgrave@online.microsoft.com

http://blogs.msdn.com/DevelopingForDynamicsGP

Any views contained within are my personal views and not necessarily Microsoft policy.
This posting is provided "AS IS" with no warranties, and confers no rights.

 

[jymm]

seems at one time someone had an excel sheet that had a tab for each module and the tables that were in there with a description of each table - THAT was a resource for GP 9 that I could not have gotten by without - even our partner took copies for several of their clients.

 

[VictoriaYudin]

Jymm, I think you're referring to Mark Polino - he has these on his blog:

http://msdynamicsgp.blogspot.com/

- it's under downloads.

Victoria Yudin
Dynamics GP MVP 2005 - 2009
Flexible Solutions - home of GP Reports

http://www.flex-solutions.com/gpreports.html

blog:

http://victoriayudin.com

 

[Dukester0122]

I haven't seen table name changes in the core modules(refer to David's post above) but saw some in Manufacturing so I don't know what msndba is referring to.