Charlotte Foust
cfoust at infostatsystems.com
Fri Jan 27 10:27:13 CST 2006
By Office 12, you're pretty much going to have to abandon the mdb anyhow, John. Might as well start early! Charlotte Foust -----Original Message----- From: dba-sqlserver-bounces at databaseadvisors.com [mailto:dba-sqlserver-bounces at databaseadvisors.com] On Behalf Of John Colby Sent: Friday, January 27, 2006 7:44 AM To: dba-sqlserver at databaseadvisors.com Subject: Re: [dba-SQLServer] SQL 2005 Server Management Studio I have to say, overall, I agree. SQL Server 2005 is FREE! It is SQL Server with a few insignificant (for the intended market) limitations. It won't use more than one processor, nor more than 1 gb of ram for it's buffers, and of course it has a max FILE SIZE of 4gb, although you can have databases in different files, each 4 GB max. For small databases it is an extremely powerful Server. Management Studio is FREE! VB Express is FREE. It integrates seamlessly with SQL Server Express, including the ability to build tables out in SQL Server right inside of VB.Net Express. My understanding is that SQL Server uses VB.NET as it's internal scripting language which opens up what you can do with Stored procedures. This is an awesome combination of FREE stuff. To be honest, once I get over the learning curve I am leaning towards abandoning the MDB as a BE. Do everything from the ground up in SQL Server Express and if the time ever comes where the client needs the power of the full on version, they just go there. No migration, no headaches. You have the ability to develop Access apps that talk to it for quick internal stuff, VB.NET and ASP.NET for Internet apps if you need them. This assumes of course that I get the "SPs are read-only" issue cleared up. John W. Colby www.ColbyConsulting.com -----Original Message----- From: dba-sqlserver-bounces at databaseadvisors.com [mailto:dba-sqlserver-bounces at databaseadvisors.com] On Behalf Of Susan Harkins Sent: Friday, January 27, 2006 8:56 AM To: dba-sqlserver at databaseadvisors.com Subject: Re: [dba-SQLServer] SQL 2005 Server Management Studio I feel the Express is just 'cripple-ware' and would recommend MySQL for small low cost jobs. ===I had to reformat to get Management Studio to work, but now that I have all the pieces working, including VB Express, I have to tell you -- it is working great and I love it. The entire package brings a level of development to the little guy that I've never seen before. They can do a whole lot and never write a line of code -- VB Express does it all for them. I have to say I disagree unless MySQL has changed a lot. I haven't looked at it in a long time, so that's possible, but it was terribly difficult to use, just a few years ago. Management Studio makes Express easy to manage. VB Express makes it easy to develop. It's a winner even though I'm still mad at MS for putting us all through so much installation crap to get here. Susan H. _______________________________________________ dba-SQLServer mailing list dba-SQLServer at databaseadvisors.com http://databaseadvisors.com/mailman/listinfo/dba-sqlserver http://www.databaseadvisors.com _______________________________________________ dba-SQLServer mailing list dba-SQLServer at databaseadvisors.com http://databaseadvisors.com/mailman/listinfo/dba-sqlserver http://www.databaseadvisors.com