Hi,

I have a windows based app coded in VB.NET, I have an MS Access database as the back end. I will eventually uplift this to MS SQL Server. but I have a few questions

1) How easy is it to convert MS Access database to SQL Server? are there any tools I can use?

2) I need to Package the app up with the database (some kind of setup), what sort of tools are available in standard VB 2008?

3)When I finally have a setup package (with the database) how do I install the SQL Server database on the clients machine assuming they already have SQL Server I just need to install my database?.

Finally off topic, can you recommend any decent licensing products for .NET apps.

cheers,
enex