473,394 Members | 1,932 Online
Bytes | Software Development & Data Engineering Community
Post Job

Home Posts Topics Members FAQ

Join Bytes to post your question to a community of 473,394 software developers and data experts.

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

Nov 13 '05 #1
2 1603
On 30 Jun 2005 06:08:27 -0700, "lcifers" <lc*****@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.
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


Nov 13 '05 #2
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

Nov 13 '05 #3

This thread has been closed and replies have been disabled. Please start a new discussion.

Similar topics

1
by: Jatin | last post by:
Hi, I have developed an application using VB 6 (SP 5), MS Access 2000 and Crystal Reports 9. I migrated from from access to SQl Server 2000. This wasn't a problem as i could import all the...
2
by: Serdar Yegulalp | last post by:
I'm in the process of migrating a lot of data (millions of rows, 4GB+ of data) from an older SQL Server 7.0 database to a new SQL Server 2000 machine. Time is not of the essence; my main concern...
2
by: lcifers | last post by:
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...
1
by: bonnie.tangyn | last post by:
Hello all I get Too few parameters expected 2 error and "The MS Jet Database engine cannot find the input table or query "myTempTablename". Make sure it exists and that its name is spelled...
6
by: Shai Levi | last post by:
Hi, I'm trying to migrate native c++ class to managed c++ class. The native class header definition looks as: class NativeClass { public: typedef void (CbFunc1)(int n,void* p);
2
by: Petr PALAS | last post by:
Hi, when I open ANY ASP.NET application on my computer I get this message: ---------------------------------------------------------------------------- ---- Server Application Unavailable ...
11
by: Neil | last post by:
We are running SQL 7, using Access 2000 as a front end. Our network person is wanting to migrate to Windows 2003 (we're currently on Windows 2000), and wants to know if we should migrate to SQL...
2
by: AS | last post by:
Hi, I have a C# windows desktop application that will be used only by one user at a time. The database server (SQL Server 2000) also resides on that machine only. This application has three...
2
by: =?Utf-8?B?UGFzcXVhbGU=?= | last post by:
I'm migrating an asp application to change the password for windows user. It based on a dll with a class to access to LDAP. The user used in this class as an ActiveDs.IADsUser. When I try this...
0
by: cathy25 | last post by:
Hi, we are planning on migrating our sql from version 2000 to 2005 (I know SQL 2005 is in market from a while). As a part of testing, i have installed sql server 2005 on my development box and able...
0
by: Charles Arthur | last post by:
How do i turn on java script on a villaon, callus and itel keypad mobile phone
0
by: ryjfgjl | last post by:
If we have dozens or hundreds of excel to import into the database, if we use the excel import function provided by database editors such as navicat, it will be extremely tedious and time-consuming...
0
by: ryjfgjl | last post by:
In our work, we often receive Excel tables with data in the same format. If we want to analyze these data, it can be difficult to analyze them because the data is spread across multiple Excel files...
0
by: emmanuelkatto | last post by:
Hi All, I am Emmanuel katto from Uganda. I want to ask what challenges you've faced while migrating a website to cloud. Please let me know. Thanks! Emmanuel
1
by: Sonnysonu | last post by:
This is the data of csv file 1 2 3 1 2 3 1 2 3 1 2 3 2 3 2 3 3 the lengths should be different i have to store the data by column-wise with in the specific length. suppose the i have to...
0
by: Hystou | last post by:
There are some requirements for setting up RAID: 1. The motherboard and BIOS support RAID configuration. 2. The motherboard has 2 or more available SATA protocol SSD/HDD slots (including MSATA, M.2...
0
marktang
by: marktang | last post by:
ONU (Optical Network Unit) is one of the key components for providing high-speed Internet services. Its primary function is to act as an endpoint device located at the user's premises. However,...
0
by: Hystou | last post by:
Most computers default to English, but sometimes we require a different language, especially when relocating. Forgot to request a specific language before your computer shipped? No problem! You can...
0
Oralloy
by: Oralloy | last post by:
Hello folks, I am unable to find appropriate documentation on the type promotion of bit-fields when using the generalised comparison operator "<=>". The problem is that using the GNU compilers,...

By using Bytes.com and it's services, you agree to our Privacy Policy and Terms of Use.

To disable or enable advertisements and analytics tracking please visit the manage ads & tracking page.