[Anthill-pro] SQL Server Migration
Christopher Power
chrispower36 at gmail.com
Thu Jun 5 16:29:28 CDT 2008
Steve,
Thanks for the info. The migration instructions do not include SQL Server
as a supported alternative, however the install instructions included with
AnthillPro include SQL Server as an option. Is it an install option but not
a migration option?
Thanks,
Chris
On Thu, Jun 5, 2008 at 5:21 PM, Steve Boone <sbb at urbancode.com> wrote:
> 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
>>
>>
>
> _______________________________________________
> 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/1363531c/attachment.htm
More information about the Anthill-pro
mailing list