Migrating from P.sql to MS SQL

[JordanCN]

We are upgrading from Dynamics 6 on a P.SQL server hopefully right up to 10 onto a W2000 x64 running MS SQL 2005 x64. I can see the steps are:

6.0 P.SQL -> 7.5 P.SQL
7.5 P.SQL -> 7.5 MS SQL
7.5 MS SQL to 9.0
9.0 to 10.0

I just can't find any docs on getting the data from 7.5 P.sql to 7.5 MS SQL. I don't see any utility on my old disks either. How does the data get migrated to the other server?

 

[VictoriaYudin]

The last time we did this for a customer was a number of years ago, but if I recall correctly, there were 2 requirements:
1. There was a Migration utility supplied by Microsoft to perform the data move from PSQL to MSSQL.
2. There was a cost involved to get new registration keys for the MSSQL version of GP.

I am not sure if there is still a cost, but I don't think you'd be able to move to MSSQL easily without the utility. Are you working with your GP Partner on this? They should be able to help you with it, I don't think this is something available directly to customers.

Also, did you say you want to put GP 10.0 on Windows 2000 Server? If so, I just wanted to mention that GP 10.0 is only supported on Windows 2003 or windows 2008 Server.

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

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

blog:

http://victoriayudin.com

 

[winthropdc]

I would suggest contacting support for the migration tool.

You can also use the Snapshot tool to assist for 3rd party products not covered with the migration tool.

http://blogs.msdn.com/developingfor...07/28/snapshot-for-microsoft-dynamics-gp.aspx

David

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

Microsoft Dynamics (formerly Microsoft Business Solutions)

http://www.microsoft.com/Dynamics

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.

 

[JordanCN]

Thanks. I got the Migration tool from MS and all worked well.