7 Replies Latest reply on Jun 29, 2012 7:23 AM by John Ossmann

Question on moving Footprints database

Joshua Humphrey Jun 27, 2012 8:26 AM

We are currently running Footprints 10 on a Windows server with MS SQL 2008 R2. I am builing a new linux (CentOS) server to run Footprints 11.1 on with a MySQL database. The idea is to continue running version 10 until all (or most) of the data is mograted to the new 11.1 installation. Has anyone ever migrated the Footprints database from MS SQL over to MySQL? If so, what steps did you take and what issues did you run into.

1. Question on moving Footprints database

Michael Santos Jun 27, 2012 8:31 AM (in response to Joshua Humphrey)

Hi Josh,

I have actually done this myself in my demonstration environment. This requires you to use a FootPrints script called mrXMLConversion.pl in FootPrints\bin to dump the FootPrints database in SQL to XML so that it can be properly imported into the MySQL side of the house.

I suggest you contact tech support and request the migration documentation for Windows SQL to Linux MySQL. I want to note that you must be on the same version on both installs (Windows and Linux) and it's recommended to migrate from 11.1 to 11.1.

Let me know if you have any questions.

Michael

Michael Santos
Software Consultant
BMC Software
1 of 1 people found this helpful
Like Show 0 Likes(0)

Actions
2. Question on moving Footprints database

Johan Gouverneur Jun 27, 2012 8:43 AM (in response to Michael Santos)

I've been waiting for the exact opposite (moving from Linux to Windows) for a bit over half a year now. The person who is working on it has had several setbacks with it along the way and there is an issue outstanding that is preventing this documentation being available. Since our installation is currently running 11.1, you might want to inquire about the 10.x documentation from support as that might be available.
Like Show 0 Likes(0)

Actions
3. Question on moving Footprints database

Joshua Humphrey Jun 27, 2012 9:10 AM (in response to Michael Santos)

Thank you for the information. Unfortunetly, we are unable to upgrade our version 10 installation to 11.1. Looks like I will need to contact Footprints' tech support to see what help they can give me on this.
Like Show 0 Likes(0)

Actions
4. Question on moving Footprints database

Michael Santos Jun 27, 2012 9:15 AM (in response to Joshua Humphrey)

No problem. Just curious... why are you unable to upgrade from 10 to 11.1?

Michael

Michael Santos
Software Consultant
BMC Software
Like Show 0 Likes(0)

Actions
5. Question on moving Footprints database

Joshua Humphrey Jun 27, 2012 9:20 AM (in response to Michael Santos)

That server is on old hardware that is running out of hard drive space and has other OS issues.
Like Show 0 Likes(0)

Actions
6. Question on moving Footprints database

Michael Santos Jun 27, 2012 9:21 AM (in response to Joshua Humphrey)

Gotcha.

Keep us updated on your progress.

Michael

Michael Santos
Software Consultant
BMC Software
Like Show 0 Likes(0)

Actions
7. Question on moving Footprints database

John Ossmann Jun 29, 2012 7:23 AM (in response to Joshua Humphrey)

Joshua,

The best way to deal with this if you can't upgrade your production environment to 11.1 is to:

1) install the same 10.x version you have now on your production environment (hopefully 10.0.2) onto the new server.

2) then perform migration steps to migrate your 10.x production install to the new server's 10.x install (with documentation provided by support).

3) Upgrade the new server's install to version 11.1 ***

*** Be advised, before installing/Upgrading to version 11.x on Unix/Linux, you must install Tomcat on the new server. Support can provide information on this.

There are incompatibility issues migrating directly from older versions into 11.x when changing databases.
1 of 1 people found this helpful
Like Show 0 Likes(0)

Actions