SQL Database

A

Andrew C

Hi

I Currently have a database with all my dvds listed in
it. I want to know if it is possible to transfer it over
to a sql database to put on my website. Hosted by an
external company.

I have around 450 records in the title table, but i also
have other tables that have actors and actresses for each
of the movies and pictures as well.

It is possible to transfer most of this over. I am trying
to reduced the amount of work i have to do without redoing
it all.

Thanks

Andrew
 
J

J. Clay

Andrew,
Depending on the amount of traffic on your site and how much updated/writing
you will do to the table, you may be just as well off using your existing
Access data. If you are the only one that will be updating the information,
it may be easiest (and cheaper) to start off using your Access and when you
start seeing degradation in you site performance you can consider moving up
to SQL. I have several sites that rely on Access databases and their
performance is very acceptable.

Jim
 
Top