I have developed a vb6 application which works off of an Access database. Originally it was to be an interim solution but I believe the powers that be want to make it a more permanent solution. This being the case, I need to get this program working off of a SQL Server database before it grows too far out of hand as an Access database.

My question: What would be involved in migrating an application based on Access over to be one based on SQL Server? Will the connection string change? Will I need to rewrite the SQL for my select/update/insert/delete queries?

I've never developed anything that used SQL Server before so this is all new to me, any advice or insight from anyone who has been down this road before would be greatly appreciated.

Many thanks!