Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
| Author |
Topic |
|
KnooKie
Aged Yak Warrior
623 Posts |
 Posted - 2003-04-04 : 11:31:05
|
| Thinking of moving up to Visual Studio .NET from Visual Studio 6. Has anyone got any knowledge from having done this about how easy it is to upgrade VB apps etc I can see there's a lot written about it on the web but has anyone got any actual experience from doing this ?A fewer pointers and/or a few wise words would be appreciatedthanks===========Paul |
|
|
smccreadie
Aged Yak Warrior
505 Posts |
Posted - 2003-04-04 : 14:03:34
|
| We're just getting started but it's been our experience that apps have to be total rewrites. We're starting to do all new app development in .Net but are most likely to leave the existing apps.Most of our stuff is asp, not vb. Someone else may have a better idea about vb. |
 |
|
|
MichaelP
Jedi Yak
2489 Posts |
Posted - 2003-04-04 : 15:00:54
|
| I've not done much desktop development, only ASP.net. I totally agree that a total re-write is pretty much the way to go. If you have your business objects in VB6 COM objects, you could reuse those.I'd take the advice of smccreadie and do all new projects in .Net and leave the old stuff alone :)As far as pointers for coding, make a base class for pretty much everything. I usually put my connection stuff in the base class so that when I'm writing a business object or ASP page I don't have to worry about the connection or connection string. I just call a "GetConnection" function and it returns a connection. The other tip is to use cacheing whenever possible. If your data doesn't have to be up to the second, you can greatly increase speed and scalability by using caching.That's my $0.02 anyway.Michael<Yoda>Use the Search page you must. Find the answer you will.</Yoda> |
|
|
|
nr
SQLTeam MVY
12543 Posts |
Posted - 2003-04-04 : 15:48:32
|
| If you try the upgrade wizard it will leave about half the code to change manually (depending on the code of course).Calling SPs is a bit different too as you have to name the parameters.Don't think it is worth the effort as you will learn more by a rewrite (and most apps can do with it occasionally anyway). The upgrade might help as a pointer though.I usually leave apps in VB6 and do new ones in .net==========================================Cursors are useful if you don't know sql.DTS can be used in a similar way.Beer is not cold and it isn't fizzy. |
|
|
|
|
|
|
Visual Studio 6 --> Visual Studio .NET