The SitePoint Forums have moved.

You can now find them here.
This forum is now closed to new posts, but you can browse existing content.
You can find out more information about the move and how to open a new account (if necessary) here.
If you get stuck you can get support by emailing forums@sitepoint.com

If this is your first visit, be sure to
check out the FAQ by clicking the
link above. You may have to register
before you can post: click the register link above to proceed. To start viewing messages,
select the forum that you want to visit from the selection below.

Hybrid View

About to switch to SQL server from access

I have a nicely setup site setup running coldfusion and a lot of queries. I have it setup so that all queries point to a variable. That way I can change the datasource the site calls on with 1 line.

So I am getting ready to go from access (current) to sql server. I am getting familiar with enterprise manager and all those apps that are used there, but I am just wondering about the sql structures. Is it likely that most of my queries will work with no change? How much different are the 2 sql languages?

I am going to test it out later, but I am just curious if there is some tips and such for the process of going from one to the other.

Support r937

Yes! they differ but just a little. You must remember that sql and access come from the same vender and sql being powerful than access, you should expect to see some changes in the query.
As r937 has already said, you need to test every query on the sql server before you start the migration.

Alright, so how would I start and yes there will be a bunch of date fields. I was looking for samples in the differences. I am not doing much with the queries yet as far as complexity, many of them are:

select * from table where ( couple of statements )

but the inserts are using code where I always do this: CreateODBCDateTime(TheDateVariable)

Makes a timestamp { .... } like that I think is how it formats it. Thats how I got it to always drop into access right. Then on the inserts, I am writing them with no ' ' so they are like this:
DateField = #CreateODBCDateTime(TheDateVariable)#

( im using coldfusion here of course ) .. these are rough examples but this is really what I was wondering about. Maybe I just import the access DB and just try it and see which break.

Is there any conversion sites / resources. I have checked around.. maybe I am not finding the right keyword or who knows but didn't have much luck yet. ( im on a modem too .. slows down the R/D process )