[ale] project help - postgres or mysql?

[Ricardo Davis]

John,

I assume that you made sure that the current application makes use of 
none of the special features of Transact-SQL.  You also should look 
at how the database is currently maintained, backed up, and recovered 
during various failure modes.

Once you've done this, you need to forward look at how the migrated 
application will be used based on business goals.  This should help 
you narrow down the choice of open source DBMS to use.


-Ricardo


>Project I'm ramping up on will involve porting a microcrap sql server db
>to either postgres or mysql.  No stored procedures on the sql server side,
>thankfully.  Just tables and indexes.
>
>The current db has a total of 227,626 rows, 249 tables.  Only 4 tables are
>over 10000...most are either in the 10s or hundreds.  Largest table is
>89890.
>(for list of counts, see http://sourceillustrated.com/projects/tblcnt.html).
>
>My initial thoughts are to use MySql, but wanted to put the question forth
>to the list.  I think mysql would have no problem handling this size, but
>want to be sure.
>
>Would postgres be a better choice?
>
>Thanks!
>
>John
>
>
>
>
>_______________________________________________
>Ale mailing list
>Ale at ale.org
>http://www.ale.org/mailman/listinfo/ale

_______________________________________________
Ale mailing list
Ale at ale.org
http://www.ale.org/mailman/listinfo/ale