473,396 Members | 2,010 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,396 software developers and data experts.

Why upgrade from VB6/SQL2000 to VB.NET 2008/SQL2008?

I have a friend who's small company is on VB6 and SQL2000 for their apps.
They would like to know what arguments (high level) there are for upgrading
to the current version/platform of VB.NET 2008 and SQL2008.

Saying "newer/better/faster" isn't a strong enough argument when the counter
to that could be "if it ain't broke, don't fix it".

Does anyone have a few bullet points that make an argument for upgrading?

Thanks.
Oct 8 '08 #1
8 3176
On Oct 8, 2:05*pm, "rcook349" <rc...@westinis.comwrote:
I have a friend who's small company is on VB6 and SQL2000 for their apps.
They would like to know what arguments (high level) there are for upgrading
to the current version/platform of VB.NET 2008 and SQL2008.

Saying "newer/better/faster" isn't a strong enough argument when the counter
to that could be "if it ain't broke, don't fix it".

Does anyone have a few bullet points that make an argument for upgrading?

Thanks.
These are for upgrading to .NET only:

1) Your staff, or the staff you plan on hiring, are proficient in .NET
and not VB6.
2) You plan on launching a web application and you would prefer to
have the website (easily) use the backend libraries. I wouldn't
recommend using old VB6 dlls from an ASP.NET, though that's mainly a
personal preference.
3) You would like to use EF / DynamicData / ADO.NET Data Services /
Castle / Nhibernate / Rhino.Mocks or one of the many other .NET only
(well, mostly) tools. Entity Framework for example could be used to
abstract your entire datatier, making the backend database(s) even
less important.

Thanks,

Seth Rowe [MVP]
http://sethrowe.blogspot.com/
Oct 8 '08 #2
Hi,

As I am now busy with an old VB6 application, every thing takes at less 3
times the time as needeed as with a version 2008, simple because in the
newer versions a lot of things are automaticly done for you, while the code
is more logical.

For VB6 it becomes almost impossible to get correct information for things
that are now common, while that was not 10 years ago.

There is a lot more, however all based on facts, that things which are now
common, where not 10 years ago. By instance the integration with mobiles,
Office, Internet etc.

Cor

"rcook349" <rc***@westinis.comschreef in bericht
news:53**********************************@microsof t.com...
>I have a friend who's small company is on VB6 and SQL2000 for their apps.
They would like to know what arguments (high level) there are for upgrading
to the current version/platform of VB.NET 2008 and SQL2008.

Saying "newer/better/faster" isn't a strong enough argument when the
counter to that could be "if it ain't broke, don't fix it".

Does anyone have a few bullet points that make an argument for upgrading?

Thanks.


Oct 9 '08 #3
LINQ

"rcook349" <rc***@westinis.comwrote in message
news:53**********************************@microsof t.com...
I have a friend who's small company is on VB6 and SQL2000 for their apps.
They would like to know what arguments (high level) there are for
upgrading to the current version/platform of VB.NET 2008 and SQL2008.

Saying "newer/better/faster" isn't a strong enough argument when the
counter to that could be "if it ain't broke, don't fix it".

Does anyone have a few bullet points that make an argument for upgrading?

Thanks.

Oct 9 '08 #4
I would add that if you want to target Vista or any any newer OS, I don't
think that SQL 2000 is going to work.

"rcook349" wrote:
I have a friend who's small company is on VB6 and SQL2000 for their apps.
They would like to know what arguments (high level) there are for upgrading
to the current version/platform of VB.NET 2008 and SQL2008.

Saying "newer/better/faster" isn't a strong enough argument when the counter
to that could be "if it ain't broke, don't fix it".

Does anyone have a few bullet points that make an argument for upgrading?

Thanks.

Oct 9 '08 #5
vb6 can only target 32bit platform

"rcook349" <rc***@westinis.comwrote in message
news:53**********************************@microsof t.com...
I have a friend who's small company is on VB6 and SQL2000 for their apps.
They would like to know what arguments (high level) there are for
upgrading to the current version/platform of VB.NET 2008 and SQL2008.

Saying "newer/better/faster" isn't a strong enough argument when the
counter to that could be "if it ain't broke, don't fix it".

Does anyone have a few bullet points that make an argument for upgrading?

Thanks.

Oct 9 '08 #6
"Gillard" <gillard_georges@@@@@@@@@hotmail.comwrote in message
news:uO**************@TK2MSFTNGP04.phx.gbl...
vb6 can only target 32bit platform

"rcook349" <rc***@westinis.comwrote in message
news:53**********************************@microsof t.com...
>I have a friend who's small company is on VB6 and SQL2000 for their apps.
They would like to know what arguments (high level) there are for
upgrading to the current version/platform of VB.NET 2008 and SQL2008.

Saying "newer/better/faster" isn't a strong enough argument when the
counter to that could be "if it ain't broke, don't fix it".
Coming from the other side of the tracks here... but, really... If it ain't
broke *don't* fix it.

If you're not writing new apps, there's no reason *at all* to migrate...
note that I say "migrate" and not "upgrade". Considering the dog/slow IDE
and the "everything including the kitchen sink - except VB specific
debugging utilities" approach to the environment... and the fact very little
code you have now will migrate without inspecting each line carefully, I
certainly wouldn't attempt to try and migrate any projects to a "less
friendly for VB" environment. (dotNet fans, save your typing, I'm not
talking about the LINQ, etc bandaids that *clearly* aren't based on the VB
language - I don't do database apps. Period)

"newer/better/faster" would only apply to "all new" development... and, even
then, if you're talking about desktop apps and haven't hit any limitations,
why bother.... besides, the jury's still out on the "better/faster" part...
no one's convinced me that dotNet's faster at *anything* and it's been out
for what.... 8 years now?.. and "better" is purely a matter of opinion...
personally, I don't like the environment. Since I've mentioned my gripes
many, many times, I won't bother now.

--
Ken Halter
Part time groupie
Oct 9 '08 #7
For a commercial product (VB6, VB.net, Java, C#...)

ADO.Net blows everthing else out of the water for performance and
functionality (depending on hardware of course) of data manipulation
against any RDBMS (sql server, Oracle,...)

If you have too much time on your hands - you could always write your
own data processing system specific to your situation in something low
level like MFC which could outperfrom ADO.Net. But for out of the box -
I have not experienced anything else that has the level of functionality
and performance as ADO.Net. But to use ADO.Net you will need either a
C# or VB.Net platform.

I haven't played with Java for a while. They may have adapted something
like ADO.Net to their platform (Just like MS stole a lot of .Net stuff
from Java).

But in MS terrirtory - I have not seen anything that could outperform
ADO.Net (.Net in general) against server based data systems (or file
based systems for that matter, text files, Excel, Word). The
Datagridview is the complement to ADO.Net. There is no way you could
create a subform in VB6 that has the level of functionality as a
datagridview - or at least with the same amount of ease.

Rich

*** Sent via Developersdex http://www.developersdex.com ***
Oct 9 '08 #8

Are you maintaining the code? Or is it stagnant?

If you're not making changes.......then don't convert it.

If you are, then you have to make a choice.
The cost of software is not development, its maintenance.

DotNet isn't going to help you if you bring bad VB6 practices with you.

Design Patterns (OO concepts) will help you create more maintainable code
as well.
Check "Head First Design Patterns" and/or www.dofactory.com for some intro
material.
You don't have to go VS2008/Sql2008 as your only option.

VS2005/SqlServer2005

VS2005/SqlServer2008

VS2008/SqlServer2005

VS2008/SqlServer2008

Those will work as well. If you're going to take the plunge, than
VS2008/Sql2008 would probably make the most sense, but I havent' looked at
the prices for licensing recently.

......................


"rcook349" <rc***@westinis.comwrote in message
news:53**********************************@microsof t.com...
>I have a friend who's small company is on VB6 and SQL2000 for their apps.
They would like to know what arguments (high level) there are for upgrading
to the current version/platform of VB.NET 2008 and SQL2008.

Saying "newer/better/faster" isn't a strong enough argument when the
counter to that could be "if it ain't broke, don't fix it".

Does anyone have a few bullet points that make an argument for upgrading?

Thanks.


Oct 13 '08 #9

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

Similar topics

1
by: LizP | last post by:
Hi, guys - looking for a bit of help/advice on moving a database from SQL 7 to SQL 2000. We've a third party application which currently uses a SQL7 database. This database has a number of views...
2
by: kg7poe | last post by:
We have Sqlsvr 6.5 under NT4. We want to upgrade the database to Sqlsvr 2000 under windows 2K. Is there any way we can do this by copying the database to the win2K computer?? At any rate would...
2
by: Saiyou Anh | last post by:
Hi! If doing online version upgrade from SQL 7.0 to SQl 2000, (1) do I need to shut down server? (2) after upgrading, is all login and db user, group information, scheduled Jobs, maintenance...
1
by: eddiekwang | last post by:
Hello, Is it necessary to upgrade the Client Connectivity Tools on all client machines after the SQL Server database server is upgraded from Version 7.0 to 2000? Thank you in advance! Eddy
3
by: Robby | last post by:
Hello I posted this to vb.upgrade but I have had no response for three days so I am giving this forum a try. I have almost completed Francesco Balena's "Programming Microsoft Visual Basic...
0
by: lsettle | last post by:
Trying to upgrade inplace from SQL 7 to SQL2000. THe upgrade options at the start of the SQL2000 install is greyed out???? We are on W2k, sp2
5
by: Saroj | last post by:
Also want to know when SQL Server 2008 is releasing. Thanks, Saroj.
4
by: Michael A. Covington | last post by:
I am happily developing software with C# using Visual Studio 2005. Should I upgrade to Visual Studio 2008? If I do, will I be able to work on the same project alternately with the two different...
1
by: BobLewiston | last post by:
I installed SQL Server 2008 Express, basic edition (SQLEXPR32_x86_ENU_Bootstrapper.exe, version 9.0.30729.1) without any problem. Then I attempted to install AdventureWorks Sample Databases for...
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: 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
0
BarryA
by: BarryA | last post by:
What are the essential steps and strategies outlined in the Data Structures and Algorithms (DSA) roadmap for aspiring data scientists? How can individuals effectively utilize this roadmap to progress...
1
by: nemocccc | last post by:
hello, everyone, I want to develop a software for my android phone for daily needs, any suggestions?
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,...
0
jinu1996
by: jinu1996 | last post by:
In today's digital age, having a compelling online presence is paramount for businesses aiming to thrive in a competitive landscape. At the heart of this digital strategy lies an intricately woven...
0
tracyyun
by: tracyyun | last post by:
Dear forum friends, With the development of smart home technology, a variety of wireless communication protocols have appeared on the market, such as Zigbee, Z-Wave, Wi-Fi, Bluetooth, etc. Each...
0
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...

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.