From owner-freebsd-questions@FreeBSD.ORG Wed Jan 4 09:32:53 2012 Return-Path: Delivered-To: freebsd-questions@freebsd.org Received: from mx1.freebsd.org (mx1.freebsd.org [IPv6:2001:4f8:fff6::34]) by hub.freebsd.org (Postfix) with ESMTP id 22F721065688 for ; Wed, 4 Jan 2012 09:32:53 +0000 (UTC) (envelope-from m.seaman@infracaninophile.co.uk) Received: from smtp.infracaninophile.co.uk (smtp6.infracaninophile.co.uk [IPv6:2001:8b0:151:1:3cd3:cd67:fafa:3d78]) by mx1.freebsd.org (Postfix) with ESMTP id 9BEA58FC19 for ; Wed, 4 Jan 2012 09:32:52 +0000 (UTC) Received: from seedling.black-earth.co.uk (seedling.black-earth.co.uk [IPv6:2001:8b0:151:1:fa1e:dfff:feda:c0bb]) (authenticated bits=0) by smtp.infracaninophile.co.uk (8.14.5/8.14.5) with ESMTP id q049WlVQ073319 (version=TLSv1/SSLv3 cipher=DHE-RSA-CAMELLIA256-SHA bits=256 verify=NO) for ; Wed, 4 Jan 2012 09:32:47 GMT (envelope-from m.seaman@infracaninophile.co.uk) X-DKIM: OpenDKIM Filter v2.4.1 smtp.infracaninophile.co.uk q049WlVQ073319 DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=infracaninophile.co.uk; s=201001-infracaninophile; t=1325669567; bh=29JJVlMM0LrBpZp4HnUgp67eiDITITcIpwM7NvAv/EM=; h=Message-ID:Date:From:MIME-Version:To:Subject:References: In-Reply-To:Content-Type:Cc; b=YMIcRSkDpPGsLKZhiIYoFC/lxxhDuIAf6GJ7W+ifTt6OH7g/3ZoJDFe+YCc8a0caN ZFFO5CNBUHJHUShrrLOsyQgy7Jdpn2bgqvvvFNoWk25Bug8fFpZddfDmg+SXeuR7D8 kSmOw2tdQDhW8SitfzuUYjrCHLkmfD9/uOAJQ5UA= Message-ID: <4F041CB9.7080704@infracaninophile.co.uk> Date: Wed, 04 Jan 2012 09:32:41 +0000 From: Matthew Seaman User-Agent: Mozilla/5.0 (Macintosh; Intel Mac OS X 10.6; rv:9.0) Gecko/20111222 Thunderbird/9.0.1 MIME-Version: 1.0 To: freebsd-questions@freebsd.org References: <4F040043.6000902@gmail.com> In-Reply-To: <4F040043.6000902@gmail.com> X-Enigmail-Version: 1.3.4 OpenPGP: id=60AE908C Content-Type: multipart/signed; micalg=pgp-sha1; protocol="application/pgp-signature"; boundary="------------enig849384D1166B0B5C8D65B212" X-Virus-Scanned: clamav-milter 0.97.3 at lucid-nonsense.infracaninophile.co.uk X-Virus-Status: Clean X-Spam-Status: No, score=-2.5 required=5.0 tests=ALL_TRUSTED,AWL,BAYES_00, DKIM_SIGNED,DKIM_VALID,DKIM_VALID_AU autolearn=ham version=3.3.2 X-Spam-Checker-Version: SpamAssassin 3.3.2 (2011-06-06) on lucid-nonsense.infracaninophile.co.uk Subject: Re: ASP running on FreeBSD via Apache/NGINX/Lighttpd X-BeenThere: freebsd-questions@freebsd.org X-Mailman-Version: 2.1.5 Precedence: list List-Id: User questions List-Unsubscribe: , List-Archive: List-Post: List-Help: List-Subscribe: , X-List-Received-Date: Wed, 04 Jan 2012 09:32:53 -0000 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--