> -----Original Message----- > From: Nick Baker [mailto:[EMAIL PROTECTED] > Sent: Sunday, January 16, 2005 1:00 AM > To: CF-Talk > Subject: Migrating from MySQL to SQL > > I am looking at a Cold Fusion shared hosting plan that only offers SQL and > MS Access. I currently use MySQL. I have used MS Access and would prefer > not to revert back to it. Intermedia.net is the company I am looking at. > Used them in the past and had excellent experience. > > My question -- What are the complications of MySQL to SQL, i.e., uploading > info and user control panel. MySql was pretty easy in both cases. Do my > work locally on MS Access. convert to CSV and upload or download. > phpMyAdmin was available and a piece of cake.
I assume you're talking about SQL Server, right? If so then I think that you'll be pleasantly surprised - it's definitely NOT Access. ;^) I don't know about that host specifically, but in most cases you would use MS SQL Server Enterprise Manager and MS Query Analyzer to do most of your work. The former is generally for more admin-type tasks (transferring data, setting up indexes, designing tables, etc) while the latter is more for day-to-day usage and data access (running queries). But there's a lot of overlap in the tools and a lot of people only use one for everything. These tools are available with any release of SQL Server: demo, evaluation, etc. Install the "Client Access Tools" only from these sources - the client tools never time out and are free for personal use. If you'll be doing any serious developing you'll probably want to install a developers version of the full database server locally anyway (usually free or very cheap, but limited to one connection). To do any sort of data transfer you'll probably use the MS Data Translation Services - this is available directly from Enterprise Manager (right click your database and choose "Tasks" then "Import Data"). Using this you can set a source of data and a destination and parameters (transformations to be done, columns to move, etc) and move the data. It's quite simple (just be damn sure you don't get your source and destination mixed up - I've done that before). Via Enterprise Manager you can also create DTS packages allowing you to run your transfers on a schedule or manually with just a click. I, for example, created a DTS package to transfer all the data from my hosted database (at CrystalTech.net) to my development server here at home and set a SQL scheduled task to do it every night at 5am. Instant backup. The DTS packager is actually quite advanced and you can link many actions together for pretty complex interactions. Anyway - follow the directions from your host for connecting the database and you should be set. I think you'll find the tool pretty clear once you have them installed. Jim Davis ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~| Find out how CFTicket can increase your company's customer support efficiency by 100% http://www.houseoffusion.com/banners/view.cfm?bannerid=49 Message: http://www.houseoffusion.com/lists.cfm/link=i:4:190617 Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4 Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4 Donations & Support: http://www.houseoffusion.com/tiny.cfm/54
