SQL Database

[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

 

[Anushi]

Hi Andrew,

The easiest and MS recommended way of your database conversion is the
upsizing wizard.

Here is the link for details:
http://support.microsoft.com/default.aspx?scid=kb;en-us;Q237980

Additional Reference:
http://msdn.microsoft.com/archive/en-us/dnarsql7/html/access2sql.asp?frame=true

http://msdn.microsoft.com/archive/en-us/dnarsqlsg/html/msdn_csupgsql.asp?frame=true

HTH,
Anushi

 

[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