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

[lcifers]

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)yaho o.com (AT) = @

TIA.

Cheers.

- Luther

[Erland Sommarskog]

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

lcifers (lcifers@yahoo. com) writes:[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?[/color]

I have no idea how to get access to SQL 7, and I will have to say that
I would reconsider migrating to SQL 7, now when SQL 2000 has been out
for so long, and SQL 2005 is just around the corner.

What could be an option, is to use SQL 2000, but set the compatibility
mode to 70, to avoid use of SQL 2000-specific features.


(By the way, if anyone wonders why SQL 6.5 is available on MSDN, it's
probably because every now and then people appear who have a backup or
a device file from 6.5, and SQL 6.5 is the only program that can read
such a file.)

--
Erland Sommarskog, SQL Server MVP, esquel@sommarsk og.se

Books Online for SQL Server SP3 at

http://www.microsoft.com/sql/techinfo/productdoc/2000/books.asp

[Terri]

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

> The next question is, does anyone know of a good resource that explains[color=blue]
> 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.
>[/color]

You could use DTS

http://builder.com.com/5100-6388-5059624.html

or the Upsizing Wizard

http://builder.com.com/5100-6388-5035130.html

I wouldn't necessarily recommend the upsizing wizard but if you search for
info on it you may discover issues that may be encountered when moving to
Access data to SQL Server. If you only have tables in your Access database
it should be fairly straightforward . If you have access queries you'll want
to pay particular attention to these.