Upsizing to SQL Server 6.5 
Author Message
 Upsizing to SQL Server 6.5

Hi

I know there is a wizard for upsizing from an Access database to the SQL
Server, but the server only allows tables, but queries. Where do you
store the queries? Does each query have to be written in SQL into the VB
front end or is there a better place to put them as stored queries -
perhaps in a middle tier between the front and back end?

Thanks



Tue, 01 May 2001 03:00:00 GMT  
 Upsizing to SQL Server 6.5
Hi Michael.

You should convert your queries to SQL Server stored procedures. This will
have to be a manual process, but you shouldn't have to modify you existing
queries very much.

HTH


and remember...

"When the going get tough, the weird turn pro."
        - R. Duke

Quote:

>Hi

>I know there is a wizard for upsizing from an Access database to the SQL
>Server, but the server only allows tables, but queries. Where do you
>store the queries? Does each query have to be written in SQL into the VB
>front end or is there a better place to put them as stored queries -
>perhaps in a middle tier between the front and back end?

>Thanks



Tue, 01 May 2001 03:00:00 GMT  
 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.



Tue, 01 May 2001 03:00:00 GMT  
 
 [ 3 post ] 

 Relevant Pages 

1. Help upsizing from FoxPro to SQL Server 6.5

2. Upsizing SQL 6.5 to SQL 7.0

3. New Transact-SQL Debugger for Microsoft SQL Server 6.5/7.0

4. Import text file in SQL Server 6.5 via SQL in Visual Basic

5. SQL Debugger for Microsoft SQL Server 7.0 and 6.5

6. Import text file in SQL Server 6.5 via SQL in Visual Basic

7. Upsize Access97 -> SQLServer 6.5

8. select Count(*) with date with sql server 6.5 and 7

9. Question regarding Access97 linking to SQL Server 6.5

10. Pessimistic Recordlocks Access --> SQL Server 6.5

11. Access 97 and SQL Server 6.5

12. Data Type Constants in SQL Server 6.5

 

 
Powered by phpBB® Forum Software