Better coding option in SQL SERVER 2000

[gorack]

If i need to convert an access application (query, tables, codes...) in SQL SERVER 2000 and i need to make code, what is the better solution (with performance and portability in mind)?

-Stored procedures (cursor is slow)
-VBScript
or a VB PACKAGE in DTS ?

 

[tlbroadbent]

When upsizing from Access to SQL Server, you want to move as much processing as possible to the server. Convert as much code to stored procedures as possible. Access action queries (Insert, Update, Delete) are good candidates for SQL Server stored procedures.

Forms, reports, VBA modules, etc. may still be usable with little or no modification. However, you will want to analyze code for efficiency and optimize it. This could require considerable changes to existing code. I recommend the following link. It contains links to many resources that will help you in the upsizing process.

Microsoft Access and SQL Integration Resources

http://msdn.microsoft.com/library/en-us/dnacc97/html/acsqlres.asp

If you want to get the best answer for your question read faq183-874 and faq183-3179.
Terry L. Broadbent - DBA
SQL Server Page:

http://tlbroadbent.home.attbi.com/sql/sql_articles.htm