http://forums.asp.net/t/469020.aspx/1?MS+SQL+v+MYSQL+is+this+true+Sun, 28 Mar 2004 12:47:10 -0500469020469020http://forums.asp.net/p/469020/469020.aspx/1?MS+SQL+v+MYSQL+is+this+true+ I have heard something like this "MySql is really not a comparable product to Sql Server. SqlServer, like Oralce, DB2 and PostgreSQL is designed to be an enterprise RDBMS server. This means that there is a server process which handles management of the data, clients have no direct access to the data store. It supports ACID transactions, online backup and recovery, declarative referential integrity, etc. MySql is an ISAM RDBMS. Architecturally MySql is more comparable to Access or FoxPro than Sql Server. As such it is perfectly suitable for many applications, but it is not designed to support large numbers of network clients, and not a safe place to keep mission-critical enterprise data. So if you are looking for a free alternative to Sql Server, you might check out PostgreSQL instead. " is this true, does postgresql a better fit for enterprise application rather than SQL if budget is tight? Please advice 2004-02-09T19:59:02-05:00505864http://forums.asp.net/p/469020/505864.aspx/1?Re+MS+SQL+v+MYSQL+is+this+true+ this is partially true however mysql could handle very large number of clients and offers very good performance, sometimes better than all other mentioned products. the new versions of mysql include transactions engine, that supports "ACID transactions, online backup and recovery, declarative referential integrity, etc." It is maybe worth mentioning, that some large corporations are using MySql, like Yahoo for example. There are of course number of features like stored procedures, views, etc that are currently not supported from MySql, altough they will be implemented in the next versions. I think, that MySql is very good for small to mid projects. If you are building big application, and your customers can afford Sql Server or Oracle it is better using them. 2004-03-13T23:31:50-05:00506162http://forums.asp.net/p/469020/506162.aspx/1?Re+MS+SQL+v+MYSQL+is+this+true+ And remember what kind of tables you use with MySQL, the myISAM doesn't provide transactions I thought, while InnoDB tables do. Postgres is said to be the bigger brother of MySQL, but in popularity among small projects MySQL rules. 2004-03-14T15:19:36-05:00509452http://forums.asp.net/p/469020/509452.aspx/1?mySQL but MySQL is better than access ? much more ? thank you 2004-03-17T13:07:50-05:00509573http://forums.asp.net/p/469020/509573.aspx/1?Re+mySQL I think you'd use access for even smaller projects :) I wouldn't be able to exactly specifiy the advantages of MySQL over Access, but I guess MySQL can take a higher load. 2004-03-17T14:32:01-05:00509599http://forums.asp.net/p/469020/509599.aspx/1?Re+mySQL then for you access is just good to remove from my computer ? :-))) 2004-03-17T14:49:39-05:00510091http://forums.asp.net/p/469020/510091.aspx/1?Re+mySQL Well actually, access is very nice to make images :p You create your tables, make your relations, and you can do it in a nice GUI, take a screenshot, et voila, your database structure in a nice way. I don't know a tool for MySQL that can do that :) Also, for creating a query fast it's a nice way (but after a while you just create them yourself, but it's nice to start from) 2004-03-17T20:14:40-05:00510486http://forums.asp.net/p/469020/510486.aspx/1?aquafold yes I know well accees and it is from far the most practicle ... thate a tool here seems very good for many databases http://www.aquafold.com/ 2004-03-18T04:55:51-05:00511210http://forums.asp.net/p/469020/511210.aspx/1?Re+aquafold Very nice tool, I use phpMyAdmin or MySQL-Front to admin my MySQL db. I checked the screenies, but can't find anything to create something like: http://users.pandora.be/tr/sst/zosa/Database-Layout.gif And that's why Access is usefull, it's a graphics tool! :p 2004-03-18T16:55:25-05:00511377http://forums.asp.net/p/469020/511377.aspx/1?Re+aquafold yes if all the databases could be like access ! 2004-03-18T18:58:12-05:00517249http://forums.asp.net/p/469020/517249.aspx/1?Re+aquafold please check for dbdesigner at http://www.fabforce.net/downloads.php GPL! ;-) 2004-03-24T12:14:16-05:00517299http://forums.asp.net/p/469020/517299.aspx/1?Re+aquafold is it better than aquafold ? thks for the link 2004-03-24T12:52:31-05:00517325http://forums.asp.net/p/469020/517325.aspx/1?Re+aquafold I got DBDEsigner 4 it seems very good .. but hiw do you ipen a database ? I click on open a database , then I get my 2 databases mySQL and Test I select one and get a small windows with a button to load the database .. if I press load i can go shopping the full day the windows keep the same position and nothing happens but why they don't just copy access ? how do you connct tio a database and create tables and columns I am turning crazy with mySQl .. if it is what they call open source .. then I love close source thanks for helping ! 2004-03-24T13:06:26-05:00521927http://forums.asp.net/p/469020/521927.aspx/1?Re+aquafold I dunno aquafold yet, testing.. which version of mysql are you using? to connect to the database, ASP , PHP, .. ? 2004-03-28T11:52:04-05:00521953http://forums.asp.net/p/469020/521953.aspx/1?Re+aquafold yes now all works i am using MySql 4 ..... to connect I use vb net but I can directly now use mySQ; Front or MuSql control Center or datasTudio aquafold 2004-03-28T12:47:10-05:00