ASP running on FreeBSD via Apache/NGINX/Lighttpd
m.seaman at infracaninophile.co.uk
Wed Jan 4 09:32:53 UTC 2012
On 04/01/2012 07:31, Jonathan Vomacka wrote:
> PS. I will need to convert the mssql data to mysql, is there any good
> program that will convert this? I understand that this question is
> probably inappropriate for this e-mail thread but maybe someone could
> shoot me a quick suggestion.
This is probably the easiest part of your porting project. What you
need to do is:
* Examine the table definitions in mssql and write equivalents for
MySQL. Ditto for other DB objects like enum types.
* Dump out table contents in CSV format -- where 'C' doesn't have to
be 'comma' necessarily: it depends on the nature of your data.
* Read the CSV files into MySQL.
* Examine all the SQL queries made by your application and translate
them into SQL that MySQL can understand.
SQL is unfortunately a horribly non-standard language. All of the
different RDBMS variants have their own dialect of it, with many
non-standard extensions. Unfortunately, while there is a SQL standard,
generally you will need to use non-standard bits either for performance
or simply because there is no way to do what you want otherwise. Also,
SQL syntax is just intrinsically horrible.
Dr Matthew J Seaman MA, D.Phil. 7 Priory Courtyard
PGP: http://www.infracaninophile.co.uk/pgpkey Ramsgate
JID: matthew at infracaninophile.co.uk Kent, CT11 9PW
-------------- next part --------------
A non-text attachment was scrubbed...
Size: 267 bytes
Desc: OpenPGP digital signature
Url : http://lists.freebsd.org/pipermail/freebsd-questions/attachments/20120104/a4e06439/signature.pgp
More information about the freebsd-questions