Skip site navigation (1)Skip section navigation (2)
Date:      Wed, 04 Jan 2012 09:32:41 +0000
From:      Matthew Seaman <m.seaman@infracaninophile.co.uk>
To:        freebsd-questions@freebsd.org
Subject:   Re: ASP running on FreeBSD via Apache/NGINX/Lighttpd
Message-ID:  <4F041CB9.7080704@infracaninophile.co.uk>
In-Reply-To: <4F040043.6000902@gmail.com>
References:  <4F040043.6000902@gmail.com>

next in thread | previous in thread | raw e-mail | index | archive | help
This is an OpenPGP/MIME signed message (RFC 2440 and 3156)
--------------enig849384D1166B0B5C8D65B212
Content-Type: text/plain; charset=ISO-8859-1
Content-Transfer-Encoding: quoted-printable

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.

	Cheers,

	Matthew

--=20
Dr Matthew J Seaman MA, D.Phil.                   7 Priory Courtyard
                                                  Flat 3
PGP: http://www.infracaninophile.co.uk/pgpkey     Ramsgate
JID: matthew@infracaninophile.co.uk               Kent, CT11 9PW


--------------enig849384D1166B0B5C8D65B212
Content-Type: application/pgp-signature; name="signature.asc"
Content-Description: OpenPGP digital signature
Content-Disposition: attachment; filename="signature.asc"

-----BEGIN PGP SIGNATURE-----
Version: GnuPG/MacGPG2 v2.0.16 (Darwin)
Comment: Using GnuPG with Mozilla - http://enigmail.mozdev.org/

iEYEARECAAYFAk8EHL8ACgkQ8Mjk52CukIx5wwCffneR6vH/EewbxbdrvbRHc+C6
v/8An3q0CuKFGuvV/R30EVOl1iN/FxkZ
=6Tsd
-----END PGP SIGNATURE-----

--------------enig849384D1166B0B5C8D65B212--



Want to link to this message? Use this URL: <https://mail-archive.FreeBSD.org/cgi/mid.cgi?4F041CB9.7080704>