[Bren.rav]

Hello evryone,

I have a Railway Reservation System Project and I have been trying for days now to look for a way to convert my VB6 project to VB .NET

Any help from where i can get a good converter or how to convert this would be very help full

Also is it possible to export Database from MS Acess to Sql for the same project.

Basically i want to use VB .Net as the front end and Sql as the Back end.

A quick reply wil greatly be appreciated. Thank you

[maj3091]

I've never used a converter to VB.Net, but if you're familiar with VB6 (ie.: you wrote the original application), you might be better trying to convert it manually. A code converter might cause you more problems than it's worth, plus it would be a good learning exercise for you.

Depending on your access and intended SQL versions, there should be no reason why you can't export the data into it.....you may end up having to script it otherwise.

[modi123_1]

Quote

Any help from where i can get a good converter or how to convert this would be very help full

For the most part - you need to do it by hand. I've found, in the projects here, that:
1. opening up each form,
2. go through the designer,
3. recreate it in the vb.net designer,
4. try to copy/paste the the code behind
5. Fix the minimal errors as needed.
6. Repeat

works the best for me. Plus, as I am going through the code fixing the language errors between vb6 and .NET I clean up old logic, bad processes, and make sure it all lines up to current spec.

Quote

Also is it possible to export Database from MS Acess to Sql for the same project.

Probably - I don't use access much anymore but an 'export' would work.. sort of. I know there are Access datatypes that are not in MSSQL. Again, for this, I would do it by hand to make sure it's done right.

[BobRodes]

Easiest way to export access to sql server is to use SSIS in SQL Server.