Upsizing Access db to SQL

[Palmyra]

I'm upsizing this access db to SQL and migrating the site code to work with it. do you know of a way to convert queries to stored procedures automatically?

 

[SQLBill]

Nope. I've never heard of any product that converts queries from Access to SQL Server. That would be nice to have though.

-SQLBill

The following is part of my signature block and is only intended to be informational.
Posting advice: FAQ481-4875

 

[simian336]

If you open your Access queries in SQL view you should be able to copy and paste the query.

It will require some clean up.

Simi

 

[djj55]

Also watch for Access UPDATE queries that are structured incorrectly for T-SQL (order of commands).

djj
The Lord is my shepherd (Psalm 23) - I need someone to lead me!