
Upsizing to SQL Server 6.5
I have not used the wizard but can tell you that the equivalent of MS Access
queries in SQL Server are called stored procedures and they are stored on
the server. Usually you create the procedure in a text editor and save the
text file then bring this into sequel server by loading it into the query
window and running it.
You can have the business logic in the front end or on the server as stored
procedures. SQL embeded in VB is not as efficient as stored procedures
stored on the server. This is because they are already compilied on the
server if stored procedures are used, and there is less network traffic.