Hello,

My name's Andrew and I'm current a student at a Technical School here in the US. I just recieved my first entry level job at a small Solutions Development company and they're giving me a "trial by fire"! I have a problem and I hope that, speaking with more experience coders like yourselves, I'll be able to get a grasp of what and where I need to go.

I've been given the task of converting data from an old database to a new database. I'm not sure as of yet (still waiting for an email about this from our C.T.O.) about the old database, but I'm quite sure the new database will be SQL Server '05. They've instructed me to use a VB.NET Console Application, but to be honest, I have NO clue what to do. The old/new database will hold around 200+ tables and the users insert the data from a front end Windows App.

I'm not sure if they want this Console App to be a one-time use only, or a multiple use because the client has literally thousands of users that use the Front End App and it may take some time for them to convert to a newer version of the Front End App (which will send the data to the new database).

Any advice/ideas/suggestions/death threats would be greatly appreciated!!!

Thanks!
Andrew