1. You should get SQL Server Software for your local machine.
2. There is an upsizing wizard specifically for upsizing your database.
You can then upsize the entire access database to SQL server on your local
machine.
3. In my experience, I have then had to go to the SQL server tables and
place primary keys and set the fields as identity fields for columns that
were "autonumber" in access.
4. Set up a connection to your new sql server database in your cf
administrator locally to test for anything that is behaving badly.
5. If everything is working fine, you need to transfer the sql server
database to your host. Ask them how people usually make this transfer.
Some hosting companies will allow you to send them a backup device from
which they can produce your database.
**I have had to create the database on the hosted machine and then upload
the data from my local machine. If this is the case, you can use the sql db
on your local machine and generate scripts that will create all of your
tables on the hosted machine. once the tables are created you can upload
your data to the hosted machine (this is where the username, password and ip
come into play).
If you have additional questions email me offline,
John Anderson
-----Original Message-----
From: Jason Larson [mailto:[EMAIL PROTECTED]]
Sent: Tuesday, November 21, 2000 12:36 PM
To: CF-Talk
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
