[Anthill-pro] SQL Server Migration
Steve Boone
sbb at urbancode.com
Thu Jun 5 16:32:04 CDT 2008
You can convert to any DB that you would like to use.
SQL supported, the instructions only give one example.
It would be the same steps.
On Thu, Jun 5, 2008 at 5:29 PM, Christopher Power <chrispower36 at gmail.com>
wrote:
> 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
>>
>>
>
> _______________________________________________
> 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/54f563e8/attachment-0001.htm
More information about the Anthill-pro
mailing list