ASP.NET Application - Migrating from Access 2000 to SQL Server 7

First off, sorry if my cross posting offends anyone. I'm posting this
in Access and SQL Server groups - not sure which one is appropriate.

I have a relatively simple ASP.NET/VB.NET application that is now
hitting an Access 2000 database over an intranet. We have to migrate
the database to SQL Server 7. My experience with ASP.NET is pretty
limited and my experience with SQL Server is nonexistent.

We have an MSDN subscription, so I went to the downloads section to get
SQL Server 7. Guess what? SQL Server 6.5 is available, as is 2000 and
2005, but no SQL Server 7. So my first question is, does anyone know if
it is available for MSDN subscribers?

The next question is, does anyone know of a good resource that explains
how to make the transition from Access 2000 to SQL Server 7? I know the
data has to be migrated and the connection between the application and
the database modified, but am really not sure exactly what to first and
the correct way to go about it. The application is a simple product
configurator. There's not a lot of data and it's not a very complex
database.

Thanks in advance. If you'd like, please copy responses to
lcifers(AT)yahoo.com (AT) = @

TIA.

Cheers.

- Luther

On 30 Jun 2005 06:08:27 -0700, "lcifers" <lcifers@yahoo.com> wrote:

If you don't have SQL Server yet, you might as well migrate to SQL
Server 2000.
The MSDN license is a *developer* license, but AFAIK not to be used
for production (MSFT is not *that* crazy to 'give' away all their
software for a few thousand bucks).
If you want a free solution, consider MSDE. Pretty adequate for low
user loads. Ships with Access 2000 and up.
Access has an Upsize Wizard to help you migrate the db (both structure
and data). Make sure you have a primary key in each table.

-Tom.


[color=blue]
>First off, sorry if my cross posting offends anyone. I'm posting this
>in Access and SQL Server groups - not sure which one is appropriate.
>
>I have a relatively simple ASP.NET/VB.NET application that is now
>hitting an Access 2000 database over an intranet. We have to migrate
>the database to SQL Server 7. My experience with ASP.NET is pretty
>limited and my experience with SQL Server is nonexistent.
>
>We have an MSDN subscription, so I went to the downloads section to get
>SQL Server 7. Guess what? SQL Server 6.5 is available, as is 2000 and
>2005, but no SQL Server 7. So my first question is, does anyone know if
>it is available for MSDN subscribers?
>
>The next question is, does anyone know of a good resource that explains
>how to make the transition from Access 2000 to SQL Server 7? I know the
>data has to be migrated and the connection between the application and
>the database modified, but am really not sure exactly what to first and
>the correct way to go about it. The application is a simple product
>configurator. There's not a lot of data and it's not a very complex
>database.
>
>Thanks in advance. If you'd like, please copy responses to
>lcifers(AT)yahoo.com (AT) = @
>
>TIA.
>
>Cheers.
>
>- Luther[/color]

Thanks, Tom. I dont think I made myself clear.

The reason to use SQL Server 7 is because that's what the client is
using. The application is not ours. We wrote it for Access 2000 and now
they have asked to have it migrated to SQL Server 7, which I have no
experience with and cannot find.

I took some time to educate myself on the topic yesterday, and now have
it hitting a SQL Server 2000 database just fine. The problem is that
our client is using SQL Server 7.

So no, I dont want to use our MSDN license for "production" <g>

Thanks. I think I'll plan on deploying onsite and having them upsize
using the wizard in Access 2000.

Cheers.

- Luther