[Opendnssec-develop] Database conversion tool
sion at nominet.org.uk
Tue Jul 3 08:31:12 UTC 2012
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?
> Opendnssec-develop mailing list
> Opendnssec-develop at lists.opendnssec.org
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.
More information about the Opendnssec-develop