 <p>Neither are a direct port, but of the two -- MySQL's syntax is more similar to SQL Server's than PostgreSQL. </p> <p>SQL Server 2000 didn't have analytic/ranking/windowing functionality -- neither does MySQL currently. Also, no WITH/CTE support - again, MySQL doesn't support this either. If you were migrating away from SQL Server 2005+, I'd have recommended PostgreSQL 8.4+ for the sake of either of the two things I just mentioned.</p>