You can purchase a demo of SQL Server from MS here:
http://developerstore.com/devstore/product.asp?productID=7555&store=TOOLBOX_
NA
it's only $10 or so.
Converting an Access db to SQL server is fairly easy if you have access to
the server with Enterprise Manager. It's a point and click process.
Yes, SQL will import all your queries, but you need to tell it to do it.
Some queries may need a little work though.
jon
----- Original Message -----
From: "Jason Larson" <[EMAIL PROTECTED]>
To: "CF-Talk" <[EMAIL PROTECTED]>
Sent: Tuesday, November 21, 2000 3:36 PM
Subject: Converting Access DB to SQL Database
>
> I am a newbie to cf and I have worked in only cf and Access. I currently
> have a database that is fairly large that is in access. How can I convert
it
> to SQL and what problems will I have with all my existing queries. My ISP
> has given me a username and password plus an IP for the SQL server. Do I
> have to call this information in my queries?
>
> I have this site running with access on my PWS, What Kind of Software do I
> need to test a SQL database on my local machine as well?
>
> Any help would be greatly appreciated.
>
> Jason Larson
> [EMAIL PROTECTED]
>
> ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~
> Structure your ColdFusion code with Fusebox. Get the official book at
http://www.fusionauthority.com/bkinfo.cfm
>
> Archives: http://www.mail-archive.com/[email protected]/
> Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~
Structure your ColdFusion code with Fusebox. Get the official book at
http://www.fusionauthority.com/bkinfo.cfm
Archives: http://www.mail-archive.com/[email protected]/
Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
