473,554 Members | 4,738 Online
Bytes | Software Development & Data Engineering Community
+ Post

Home Posts Topics Members FAQ

Upgrading ASP w/SQLserver 2000 to ASP.NET w/ SQLserver 2005

I have some old ASP programs w/ SQLserver 2000 databases. Now I am
developing ASP.NET projects using VB 2005 and SQLserver 2005. What are the
best procedures to develop and test the ASP.NET programs?

My main concerns are:
1. What do I need to test? VB 2005/ASP.NET with 2000 data? Migration of
2000 data to SQLserver 2005? VB 2005/ASP.NET with 2005 data?
2. How to minimize the transition time? What is the critical change for
the end users? SQLserver 2000 to 2005 or ASP to ASP.NET?
Apr 6 '07 #1
2 1674
I have some old ASP programs w/ SQLserver 2000 databases. Now I am
developing ASP.NET projects using VB 2005 and SQLserver 2005. What
are the best procedures to develop and test the ASP.NET programs?

My main concerns are:
1. What do I need to test? VB 2005/ASP.NET with 2000 data? Migration
of
2000 data to SQLserver 2005? VB 2005/ASP.NET with 2005 data?
2. How to minimize the transition time? What is the critical change
for
the end users? SQLserver 2000 to 2005 or ASP to ASP.NET?
There is an upgrade-check tool to check if a sql200 database can be converted

to a sql2005 database. It will suggest changes. Our sql2000 database required
minor
changes to work in sql2005 and those changes could also be applied to the
sql2000
version.

ASP to ASP.Net is an entirely different matter. Those environments differ
so much
that there is no easy conversion from ASP to ASP.Net. There *are* some tools
"out there" that claim to be able to convert, but I doubt that the result
will
be a useful site. The site might work, but I expect it to be very difficult
to
maintain.

Hans Kesting
Apr 6 '07 #2

ASP to ASP.NET?
Yeah dude. Plan on a complete port over, if you want to do it right.

If you dotNet code has references to ADODB, then you're barking up the wrong
tree.
(which is one of many bad things the upgrade wizards do)

I'll start you off with this tidbit.

NUMBER 1 THING NOT TO DO IN ASP.NET

Loop over recordsets and create html code.
Asp.Net has controls which you bind data.

asp:repeater
asp:GridView (2.0)
asp:dataGrid(1. 1)

are examples.

DO NOT LOOP OVER RECORDSETS AND CREATE HTML CODE.

Good luck.


"Jeffrey" <cj*******@gmai l.comwrote in message
news:9F******** *************** ***********@mic rosoft.com...
I have some old ASP programs w/ SQLserver 2000 databases. Now I am
developing ASP.NET projects using VB 2005 and SQLserver 2005. What are
the
best procedures to develop and test the ASP.NET programs?

My main concerns are:
1. What do I need to test? VB 2005/ASP.NET with 2000 data? Migration of
2000 data to SQLserver 2005? VB 2005/ASP.NET with 2005 data?
2. How to minimize the transition time? What is the critical change for
the end users? SQLserver 2000 to 2005 or ASP to ASP.NET?

Apr 27 '07 #3

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

Similar topics

3
1717
by: Peter Morris | last post by:
What's the deal with SQLServer 2005 Beta? I've just got a magazine with a free cover disk with VB 2005 beta, and also includes SQLServer 2005. I've installed it, but I can't get it to do anything. It seems to have installed ok, there are the data files for allthe usual system and example databases in place, and Task Manager shows that...
5
512
by: Mike Owen | last post by:
Hi, I have just used the import Wizard to import a VS 2003 app to VS 2005. I have a lot of work to do to enable it to compile successfully with all the errors and warnings it gave me, but as a starting point the compiler can no longer find the function as at the bottom of this posting, that was in the Global.asax.vb file. All the...
14
2117
by: Roy Gourgi | last post by:
Hi, I need to store and retrieve information from a database. It looks as though there is a lot more support for SQLServer than there is for Access, correct me if I am wrong. What do I have to do to get SQLServer and which version should I be using. Or is SQLServer already part of the VS.Net? Are there any good examples that you know of.
0
1039
by: Ron | last post by:
Hi there My company is developing a web based document archival and retrieval system, using ASP.NET, c# and sqlserver 2000. This development is in testing at present and all looks promising. Here's some background to the app... Our application stores the document in an image field along with other information related to the document...
3
1617
by: Dan Sikorsky | last post by:
Can I use SQLServer 2000 with ASP.NET 2.0 instead of SQLServer 2005, and use the .Net 2.0 Membership functionality? I've setup my Login page, controls, etc., and now it's time to use the Web Site Administration Tool (WAT) but it won't sense my SQLServer 2000 database.
5
1353
by: John | last post by:
Hi I have an access 97 app which I have the option to upgrade to either access 2000 or access 2003. Which one should I choose. I have heard nasty things about access 2000. Thanks Regards
2
1425
by: C.O.Jones | last post by:
I've previously used version 7 and 2000. I've recently started to learn ASP.net. I've installed Visual Web Developer 2005 Express and this includes SQLServer 2005 in the installation. The task manager and and the list of services definitely show I've got SQLServer running on my computer. Here's the problem: how do I actually use it? I...
1
4132
by: powersof2 | last post by:
Hello, I need some help with SQL Server 2000 SP4. I've been using the developer product for a few years now on my PC with very few problems. Today when I try to start up Enterprise Manager, it crashes immediately. I get the usual "Please tell Microsoft about this problem" dialog and if I click the 'click here' link, I'm presented with a...
38
1926
by: kavsak | last post by:
Hi. Not sure that this is the right place to ask but here goes. I have an application based on access97 and VB6 which I need to upgrade. It has to handle up to 20 concurrent users on a Win2k network ( to be upgraded to XP next year) which has no connection to the outside world, but normally there are no more than 2. It has approximately 150...
0
7541
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 effortlessly switch the default language on Windows 10 without reinstalling. I'll walk you through it. First, let's disable language...
0
7821
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, it seems that the internal comparison operator "<=>" tries to promote arguments from unsigned to signed. This is as boiled down as I can make it. ...
0
6172
agi2029
by: agi2029 | last post by:
Let's talk about the concept of autonomous AI software engineers and no-code agents. These AIs are designed to manage the entire lifecycle of a software development project—planning, coding, testing, and deployment—without human intervention. Imagine an AI that can take a project description, break it down, write the code, debug it, and then...
1
5452
isladogs
by: isladogs | last post by:
The next Access Europe User Group meeting will be on Wednesday 1 May 2024 starting at 18:00 UK time (6PM UTC+1) and finishing by 19:30 (7.30PM). In this session, we are pleased to welcome a new presenter, Adolph Dupré who will be discussing some powerful techniques for using class modules. He will explain when you may want to use classes...
0
3591
by: TSSRALBI | last post by:
Hello I'm a network technician in training and I need your help. I am currently learning how to create and manage the different types of VPNs and I have a question about LAN-to-LAN VPNs. The last exercise I practiced was to create a LAN-to-LAN VPN between two Pfsense firewalls, by using IPSEC protocols. I succeeded, with both firewalls in...
0
3571
by: adsilva | last post by:
A Windows Forms form does not have the event Unload, like VB6. What one acts like?
1
2033
by: 6302768590 | last post by:
Hai team i want code for transfer the data from one system to another through IP address by using C# our system has to for every 5mins then we have to update the data what the data is updated we have to send another system
1
1154
muto222
by: muto222 | last post by:
How can i add a mobile payment intergratation into php mysql website.
0
861
bsmnconsultancy
by: bsmnconsultancy | last post by:
In today's digital era, a well-designed website is crucial for businesses looking to succeed. Whether you're a small business owner or a large corporation in Toronto, having a strong online presence can significantly impact your brand's success. BSMN Consultancy, a leader in Website Development in Toronto offers valuable insights into creating...

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.