[Anthill-pro] SQL Server Migration

[Steve Boone]

Christopher,

I would first upgrade the anthillpro server to the newest version, and then
migrate.

I have put instructions for migrating below.

Instructions for upgrading the server can be found on the website.

Migrate Server Database

We have seen some scalability issues with the embedded Apache Derby
database. If you experience slowness in the AnthillPro Web UI or if the
server process is taking up too much memory, it is likely time to migrate to
a different database.

The AnthillPro command line installers include a database migration utility
that exports your existing database data and imports it into another
supported database. The following alternative databases are supported:

   -

   *Oracle*.
   -

   *MySQL* (works with 4.1.22 and later).
   -

      If using MySQL 5, use the 5.0.8 driver version. The 5.1 version has
      some bugs that will cause the AnthillPro server to throw an error. If you
      are using the 5.1 version, switch the driver jar file in the server's
      lib/ext directory and then restart.

Database Requirements

These requirements apply if you want to use a database other than Apache
Derby:

   1.

   You must use one of the command line installers for installation.
   2.

   You need to download the appropriate JDBC driver file for your database.
   These are typically downloaded from the database vendor.
   3.

   You need to create an empty database for AnthillPro to use with a
   dedicated user.
   -

      The database migration should only be run after you have completed an
      upgrade to the version you are using to migrate. So if you download a new
      version and want to migrate, you must first do an upgrade.

Windows Database Migration from .zip File

To migrate the AnthillPro database:

   1.

   Download the *anthill3-<version>.zip* file.
   2.

   *Expand* the zip file using a tool like WinZip. Expanding will create an
   *anthill3-install* directory.
   3.

   Open the *anthill3-install* directory created in the previous step
in *Windows
   Explorer*.
   4.

   Copy the *JDBC driver file(s)* of the database you are migrating to into
   the *anthill3-install\lib\ext* directory.
   5.

   Run the migration script *migrate-db.bat*.
   6.

   If the AnthillPro server is installed as a *Windows service*: Input
the *unique
   name* in the dialog box and click *OK* to stop and remove service
   (Windows service may be recreated, if desired, in step 10).
   -

      If more than one AnthillPro server is installed as a Windows service,
      make sure the correct service name is entered.
      7.

   Provide the *directory* where the AnthillPro server is installed.
   8.

   Input *Y* to *upgrade* the existing server.
   9.

   Provide the following:
   -

      *Database type* AnthillPro should migrate to [derby, oracle, mysql].
      -

      *Database driver.* See your database vendor documentation for the JDBC
      driver class to use.
      -

      *Database connection string.* See your database vendor documentation
      on the format of this value.
      -

      *Database user name.*
      -

      *Database password.*
      10.

   Follow the remainder of *step 7 through step 10 of the Windows
   installation* process. See Windows Server Installation from zip
File<http://localhost:8080/help/html/ch04.html#windowsinstall>
   .

Linux/Unix Database Migration from .tar.gz File

To migrate the AnthillPro database, follow the steps below:

   1.

   Download the *anthill3-<version>.tar.gz* file.
   2.

   Open a *UNIX shell* to the directory containing the above downloaded
   file.
   3.

   *Extract* the downloaded *tar.gz* file. Type tar -zxf
   anthill3-<version>.tar.gz. On some installations of Solaris and HP-UX the
   default tar command will not properly handle our tar files. You may need to
   use \ install GNU tar.
   4.

   cd *anthill3-install*.
   5.

   Copy the *JDBC driver file(s)* of the database you are migrating to into
   the *anthill3-install/lib/ext* directory.
   6.

   *Run* the migration script *./migrate-db.sh*.

During the migration you will be prompted for the following information:

   1.

   *Directory* where the AnthillPro *server* is installed.
   2.

   *Database type* AnthillPro should migrate to [derby, oracle, mysql].
   3.

   *Database driver.* See your database vendor documentation for the JDBC
   driver class to use.
   4.

   *Database connection string*. See your database vendor documentation on
   the format of this value.
   5.

   *Database user name.*
   6.

   *Database** password.*



On Thu, Jun 5, 2008 at 3:30 PM, Christopher Power <chrispower36 at gmail.com>
wrote:

> Hi,
>
> I have AnthillPro 3.4.9 installed and running using the packaged Apache
> Derby DB.  I'd like to install the latest version of Anthill, and migrate my
> DB to SQL Server.  Is there any documentation surrounding the migration
> process?
>
> Thanks,
> Chris Power
>
> _______________________________________________
> Anthill-pro mailing list
> Anthill-pro at lists.urbancode.com
> http://lists.urbancode.com/mailman/listinfo/anthill-pro
>
>
-------------- next part --------------
An HTML attachment was scrubbed...
URL: http://lists.urbancode.com/pipermail/anthill-pro/attachments/20080605/99ca46b8/attachment-0001.htm