[Opendnssec-develop] Database conversion tool

[Siôn Lloyd]

On 02/07/12 15:37, Jerry Lundström wrote:
> I'm going to make a small perl script to convert between SQLite and
> MySQL and I wonder if there is anything specific to think about like
> do we use utf8 in zone name etc?
>
> /Jerry
> _______________________________________________
> Opendnssec-develop mailing list
> Opendnssec-develop at lists.opendnssec.org
> https://lists.opendnssec.org/mailman/listinfo/opendnssec-develop

One thing that I was thinking about is where we have used tinyint or 
mediumint in the mysql schema but integer in the sqlite schema. However 
I think there should be no real issues unless someone has more than 127 
HSMs or 8,388,607 zones/policies (good luck with that).

The other thing is that in sqlite timestamps are stored as varchars; 
that should not be a problem, just something to be aware of.

Sion