Access 2000 db to Sql server 2005 db

[barmatt80]

How hard is it if you already have the site setup as access as the datasource to then take that same site to start using sql server 2005 db? Not the actual process of moving the database, but as far as making the site work with sql server opposed to the access db.

a bit more info:

I don't know anything about coldfusion. But we have someone that wrote a website using cold fusion and the data source is access 2000. We are going to move from access to sql server 2005.

Just a small portion of the site is actually cold fusion, just the part to query the database, which is why we are hoping not to rewrite the website in a different technology.

Thanks for your help!

[acoder]

You would need to log into the Coldfusion Administrator and go to Data Sources and point to the new database.

It should work as long as the queries work in SQL Server too.

[barmatt80]

Am I over simplifying this? So change the data connection in the cold fusion administrator and that is it? Granted like you said the queries work the same in sql and that names of database fields and data types remained the same?

if so that is awesome! Thanks for your help!

[acoder]

Yes, that should be it as long as you use the same name (unless you have one place in the code where the datasource name is set which you could change).