Access has an upsizing wizard built into it--you just have to launch the wizard and tell it where your SQL Server database is, and it handles the rest. There are some tools to convert Access into MySQL as well. I haven't used any in years because I haven't used Access in years, but last I knew what it did was analyze the Access database and create a script that would create the MySQL database with the appropriate datatypes, etc. I don't have any links handy but if you google on it you should find some tools.
Matt On Sat, 30 Oct 2004 11:55:00 -0500, Jake <[EMAIL PROTECTED]> wrote: > What's the best way to upsize an Access DB to SQL Server and/or MySQL? > Has someone created tools to do that? I've always done it by hand so far. > > Tom Nunamaker wrote: > > >Nice link Daniel. I completely agree that Access is unsuitable for most > >people. Microsoft does say you can use it to build a database and > >upsize it to SQL server, but I've found the tools in SQL server to be > >more than adequate for developing (with the exception of debugging > >stored procedures...) Most of the "problems" in that link can be > >avoided if you put the database outside of the web root and use > >cachedwithin for most of your CFQUERY tags. I wouldn't have a problem > >for a new site using Access as the hit counts are generally really > >really low initially. Of course, if it becomes successful, which you'll > >know fairly soon, then moving to SQL server is assumed. I don't use > >Access anymore myself because of TransAct-SQL and stored procedure that > >I use when building sites. The point was you can use Access as long as > >you are aware of the limitation. :) > > > > > >Kind regards, > > > > > >Tom Nunamaker > > > > > > > >-----Original Message----- > >From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On > >Behalf Of Daniel Elmore > >Sent: Saturday, October 30, 2004 2:43 AM > >To: [EMAIL PROTECTED] > >Subject: RE: Data sources > > > > > >Good article Tom. > > > >Here's a link I refer people to when they don't understand why access > >should not be used as a datasource. > > > >http://www.aspemporium.com/tutorials.aspx?tid=12 > > > > > >- Daniel Elmore > > > > > >-----Original Message----- > >From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On > >Behalf Of Tom Nunamaker > >Sent: Friday, October 29, 2004 6:57 PM > >To: [EMAIL PROTECTED] > >Subject: RE: Data sources > > > >That depends on whether or not you can cache everything.. :) If it's > >just read only, load it in RAM and off you go. Remember when Toys-R-Us > >had a CF site that loaded their entire catalog structure into the > >application scope??? > > > > > >Kind regards, > > > > > >Tom Nunamaker > > > > > > > >-----Original Message----- > >From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On > >Behalf Of Matt Woodward > >Sent: Saturday, October 30, 2004 12:10 AM > >To: [EMAIL PROTECTED] > >Subject: Re: Data sources > > > > > >Access is not meant to be and was never meant to be a multi-user > >database system. Even MS admits that. Using it as a backend for a web > >site that gets even moderate traffic is asking for trouble. It's not a > >question of whether or not it will blow up, it's a question of when. If > >the choice is between Access and SQL Server, there is no real choice > >other than SQL Server. Getting off Access is 110% necessary. > > > > > >On Fri, 29 Oct 2004 15:06:20 -0700, Colin Wilson > ><[EMAIL PROTECTED]> wrote: > > > > > >>In this case - the first two options are access or sql 2000... The > >>mysql is a possible but most likely we'd go for sql... Just trying to > >>get a bit more info to use in convincing the company that the > >>development time to convert to sql is necessary. > >> > >>Colin > >> > >> > >> > >>-----Original Message----- > >>From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On > >>Behalf Of Jacob Cameron > >>Sent: October 29, 2004 3:01 PM > >>To: [EMAIL PROTECTED] > >>Subject: RE: Data sources > >> > >>The person said 'read only data', so not having backups is OK and > >>mySQL runs much faster for that type of system. > >> > >>Heck, I'd use mySQL and cache the heck out of your webserver. The > >>database choice doesn't really matter as long as you are just reading > >>data. > >> > >>Jacob > >> > >>-----Original Message----- > >>From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On > >>Behalf Of Tom Nunamaker > >>Sent: Friday, October 29, 2004 4:51 PM > >>To: [EMAIL PROTECTED] > >>Subject: RE: Data sources > >> > >>I know mySQL is improving, but the last time I looked at it, it didn't > >> > >> > > > > > > > >>have many features that a robust DB server has: Stored procedures, > >>views, UDF's, etc. What's the reasoning someone wants to use mySQL? > >> > >>Tom Nunamaker > >> > >>-----Original Message----- > >>From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On > >>Behalf Of Colin Wilson > >>Sent: Friday, October 29, 2004 11:29 PM > >>To: [EMAIL PROTECTED] > >>Subject: Data sources > >> > >>Does anyone have specifics about the best database to use for cold > >>fusion.. Currently our site uses access as the database but I could > >>set up SQL2000 - one of the guys at the company would rather use > >>mysql... > >> > >>So of these - for fast response with lots of requests per minute.... > >>Basically in a read only situation... Which database would be our > >>best. > >> > >>All three are available options. > >> > >>Colin > >> > >>---------------------------------------------------------- > >>To post, send email to [EMAIL PROTECTED] > >>To unsubscribe: > >> http://www.dfwcfug.org/form_MemberUnsubscribe.cfm > >>To subscribe: > >> http://www.dfwcfug.org/form_MemberRegistration.cfm > >> > >>---------------------------------------------------------- > >>To post, send email to [EMAIL PROTECTED] > >>To unsubscribe: > >> http://www.dfwcfug.org/form_MemberUnsubscribe.cfm > >>To subscribe: > >> http://www.dfwcfug.org/form_MemberRegistration.cfm > >> > >>---------------------------------------------------------- > >>To post, send email to [EMAIL PROTECTED] > >>To unsubscribe: > >> http://www.dfwcfug.org/form_MemberUnsubscribe.cfm > >>To subscribe: > >> http://www.dfwcfug.org/form_MemberRegistration.cfm > >> > >>---------------------------------------------------------- > >>To post, send email to [EMAIL PROTECTED] > >>To unsubscribe: > >> http://www.dfwcfug.org/form_MemberUnsubscribe.cfm > >>To subscribe: > >> http://www.dfwcfug.org/form_MemberRegistration.cfm > >> > >> > >> > >> > > > > > > > > > > ---------------------------------------------------------- > To post, send email to [EMAIL PROTECTED] > To unsubscribe: > http://www.dfwcfug.org/form_MemberUnsubscribe.cfm > To subscribe: > http://www.dfwcfug.org/form_MemberRegistration.cfm > > -- Matt Woodward [EMAIL PROTECTED] http://www.mattwoodward.com ---------------------------------------------------------- To post, send email to [EMAIL PROTECTED] To unsubscribe: http://www.dfwcfug.org/form_MemberUnsubscribe.cfm To subscribe: http://www.dfwcfug.org/form_MemberRegistration.cfm
