I have a GreatPlains 9.0 installation on SQL 2008R2. On that platform, I am unable to install SP4 for GP 9.0, which is required to be installed prior to being able to upgrade to GP10.0 or GP 2010.
Therefore, I have been trying to find ways to downgrade the GP databases to SQL 2005. I have a separate server setup that has SQL 2005 w/ SP4 installed. The two databases in question are DYNAMICS (the GP config and app DB) and KUTR (the actual company data).
I tried the script creation wizard in SQL 2008 to create a script that would create not only the schema, but also data on the SQL 2005 server. I selected options to continue on error, Script for SQL 2005, script schema and data. That worked except for one stored procedure that is encrypted. Then I executed that script on the SQL 2005 instance and it worked except the parts where it referenced the DYNAMICS database. At that point, I realized that the DYNAMICS database has to be migrated first.
Based upon the success of the previous technique, I presumed that I would have no issues scripting the schema and data in the DYNAMICS database into a SQL 2005 compatible script by using the script creation wizard.
However, that is not the case. The script creation fails right away with the error in the attached file.
Would you please look at the attached file and let me know what you think about why it is failing and what I can do about it?
I don't understand why using the script creation wizard would work for the KUTR database, but not the DYNAMICS database.