Converting to SQL Server

[Powderfinger]

I'd like to convert a database from Access 2000 to SQL server. Does anyone
have any advice as to how to get started?

 

[Klatuu]

Use the upsizing wizard.
Tools, Database Utilities, Upsizing wizard.

 

[Dale Fye]

Don't know whether it is still in publication, but the :Microsoft Access
Developer's Guide to SQL Server", SAMS, Chipman and Baron is very useful.
The version I have was written in 2001, but I refer to it on a regular basis.

 

[Powderfinger]

It seemed to work incredibly well. even without touching the VBA code, which
I had made sure was ADO. I did not have to create any stored procedures or
views. I'm almost in shock. The macros work , which I did not think was
going to based upon some articles i read.

The db is relatively simple and small, a fews forms and reports centered
around a contact table which has about 500,000 records in it. Right now I
have the trial db on a windows 2000 machine running SQL server 2005 trial
version, and a single client with Access 2003. What astounds me the most is
that I did not have to make any modifications to the client. Just share a
directory on the server and plop the file down, just like you would do for a
normal access file. I guess it automatically figures out the ODBC
connection.

I did order the book that Dale suggested. I know that there are several
different ways to hook up an access front end with a server db. My biggest
question mark is, if i go to production , what happens if the db goes
corrupt? I have a lot to learn.

 

[JohnE]

I also suggest researching for getting a good SQL2005 book. There are many
out there and it becomes mainly a personal preference. I have been moving
dbs and find a good book very useful. Inside Sql the are jobs to allow for
backing up the db on a regular schedule or as often as needed. There is one
db that backs up 3 of the tables every 15 minutes as the info in those tables
are mission critical. Otherwise, the whole db gets backed up 4 times during
a 24 hr period. All of this is accomplished thru SQL and does not require
stored procedures. To point you in the direction, on the Object Explorer of
SQL you should see at the bottom of the server list "SQL Server Agent" (if
all of SQL was installed). If there isn't a + next to it, you need to turn
it on by right clicking on it and selecting START. Expand it and this is
where you will need a book to help you thru it. Good luck and enjoy.
.... John