GX DeveloperWeb

gxdeveloperweb.com

wcmexchange.com

Home
Forums
Installation

Forums

Sign in

Register | Forgot password

Active forums

July 27, 21:52

July 27, 09:28

July 22, 16:59

July 22, 08:46

July 19, 17:57

experience with WM 8.3 database migration MSSQL 2000 to 2005 ?

The "Installation" forum contains threads on installation issues with GX WebManager. Check this forum if you encounter problems during a manual setup or if you use the installer. This forum supports all operating systems (Unix flavors, MS Windows) and all databases (MySQL, MS SQL and Oracle). You can also use this forum to suggest improvements on the installation procedure and documentation.

Answered
Not marked as answered yet

Forums > Installation > experience with WM 8.3 database migration MSSQL 2000 to 2005 ?

Author

experience with WM 8.3 database migration MSSQL 2000 to 2005 ?

abouaabasslam

Posts: 5

Posted: 17-07-2009 12:51

Hi there,

Does anyone have experience with database migration of WM 8.3 from MSSQL 2000 tot 2005?

Any tips?

Thanks in advance!
Abdessamad

leonb

Posts: 8

Posted: 18-07-2009 22:11

Solved

We (GX) have several WM83 customer sites running on MS-SQL2005. There can be some minor problems when using certain queries because they are scripted in such a way the execution order is suboptimal in MS-SQL2005.

Besides that it's just a question of changing your setup.properties (and running ant fixconfigonly/updateconfig) Changing the server.xml and changing the database references either by fixing them directly in the SwDatabase table or by using "edit the databases".

wonn1377

Posts: 1

Posted: 25-08-2009 12:34

I think u should use a third party help to resolve this problem, i use dbload to solve it when i was migrated my data, it can migrate almost any data, it helps me to convert MSSQL to MYSQL, MS access to MSSQL, mysql, csv loader, foxpro and MSSQL to MS access, MYSQl, CSV, foxpro etc. i found it on google search.

Download Free : http://www.dbload.com

patricka

Posts: 255

Posted: 25-08-2009 14:18

Commercial spam for free TRIAL version detected!

Migrating your database from MSSQL 2000 to MSSQL 2005 doesn't require any extra tool, since MSSQL 2005 will take care of that.

What Leon is pointing out, is that there might be minor problems with queries because of differences between MSSQL 2000 and MSSQL 2005. No tool is going to help you with optimizing those, it will need to be done manually.

Greetings,

Patrick

Back to top

New message: "experience with WM 8.3 database migration MSSQL 2000 to 2005 ?"

Message:

© 2010 GX creative online development B.V.

Disclaimer

This website (GXdeveloperweb.com) may discuss or contain opinions, (sample) coding, software or other information that does not include GX official interfaces, instructions or guidelines and therefore is not supported by GX. Changes made based on this information are not supported. GX will not be held liable for any damages caused by using or misusing the information, software, instructions, code or methods suggested on this website, and anyone using these methods does so at his/her own risk. GX offers no guarantees and assumes no responsibility or liability of any type with respect to the content of this website, including any liability resulting from incompatibility between the content of this website and the materials and services offered by GX. By using this website you will not hold, or seek to hold, GX responsible or liable with respect to the content of this website.