Velocity Reviews - Computer Hardware Reviews

Velocity Reviews > Newsgroups > Programming > ASP .Net > Upgrading ASP w/SQLserver 2000 to ASP.NET w/ SQLserver 2005

Reply
Thread Tools

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

 
 
=?Utf-8?B?SmVmZnJleQ==?=
Guest
Posts: n/a
 
      04-06-2007
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?
 
Reply With Quote
 
 
 
 
Hans Kesting
Guest
Posts: n/a
 
      04-06-2007
> 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


 
Reply With Quote
 
 
 
 
sloan
Guest
Posts: n/a
 
      04-27-2007

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" <(E-Mail Removed)> wrote in message
news:(E-Mail Removed)...
> 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?



 
Reply With Quote
 
 
 
Reply

Thread Tools

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

BB code is On
Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are Off


Similar Threads
Thread Thread Starter Forum Replies Last Post
ExecuteNonQuery returning -1 (vb+asp.net+sqlserver 2000) jzogg7272@gmail.com ASP .Net 2 08-09-2006 08:40 PM
ASP.NET 2.0 and SQLServer 2000 =?Utf-8?B?U3RldmU=?= ASP .Net 2 06-27-2006 04:43 AM
Can ASP.NET 2.0 Use SQLServer 2000 For Membership Function Dan Sikorsky ASP .Net 3 04-11-2006 02:52 PM
How to insert word document in sqlserver 2000 using asp.net aparna ASP .Net 1 08-12-2005 11:35 AM
Connecting to SQLServer 2000 from ASP.NET Patrick ASP .Net 11 04-27-2004 08:09 AM



Advertisments