-
1. Question on moving Footprints database
Michael Santos Jun 27, 2012 8:31 AM (in response to Joshua Humphrey)1 of 1 people found this helpfulHi 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 -
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.
-
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.
-
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 -
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.
-
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 -
7. Question on moving Footprints database
John Ossmann Jun 29, 2012 7:23 AM (in response to Joshua Humphrey)1 of 1 people found this helpfulJoshua,
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.