[Opensim-dev] PostgreSQL data module for OpenSim

[Fernando Francisco de Oliveira]

I hope so. I want to see it in production soon. cant wait to compile it
from oficial repository :)

I'm working on the database migration tool, and it is almost done. (mysql
to postgresql) or any direction (even sqlite to postgres), mssql to
postgres.
as prototype its fixed to mysql to postgres, but adding the database
plugin, like opensim itself, it can be done only configuring the INI file.

like this:
[Setup]
Databases = myopensim,osmyothersim

[DatabaseOrigin]
StorageProvider = OpenSim.Data.MySQL.dll
ConnectionString = "Data Source=localhost;User ID=root;Password=***;Old
Guids=true;Database="

[DatabaseTarget]
StorageProvider = OpenSim.Data.PGSQL.dll
ConnectionString = "User
ID=postgres;Password=***;Host=localhost;Port=5432;Database="



Fernando Oliveira
http://oliveira.eti.br

http://twitter.com/oliveira_lands




2013/10/11 James Hughes <jamesh at bluewallgroup.com>

> On 10/10/2013 10:09 PM, Fernando Francisco de Oliveira wrote:
>
>> Hello
>>
>> I just requested a push from my fork of opensim to the nebadon git
>> opensim repository, that I created the PostgreSQL project to use this
>> database in opensim.
>>
>> https://github.com/ffoliveira/**opensimulator/tree/PostgreSQL<https://github.com/ffoliveira/opensimulator/tree/PostgreSQL>
>>
>> I already have a Mantis Account.
>>
>> I hope the code and it's use may improve opensim performance and gain
>> more users.
>>
>> Fernando Oliveira
>> http://oliveira.eti.br
>>
>> http://twitter.com/oliveira_**lands <http://twitter.com/oliveira_lands>
>>
>>
> Thanks Fernando. I have always been suspect of projects that had no PgSQL
> support :) I think it will be a nice addition to our little project.
>
> BlueWall
>
>
>
> ______________________________**_________________
> Opensim-dev mailing list
> Opensim-dev at lists.berlios.de
> https://lists.berlios.de/**mailman/listinfo/opensim-dev<https://lists.berlios.de/mailman/listinfo/opensim-dev>
>
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://opensimulator.org/pipermail/opensim-dev/attachments/20131011/ca219e8f/attachment-0001.html>