Upsizing: more than the FAQs

[snyderj]

I've read the numerous Tek-Tips upsizing responses and FAQs, which have been helpful, thank you.

Now onto the next stage: seeking URLs and reference books for complex upgrades to SQL 2K (which may mean re-building from scratch).

The Access 2K db in question has outgrown its britches by a long shot (in terms of automation and links, not db size, which is only 2 MB). Here's what I have:[ul][li]13 ODBC linked tables[/li]
[li]Eight linked tables from a separate Access 2K MDB (for user data storage)[/li]
[li]21 queries (delete, make, append and update) sequenced through a macro (38 lines, including conditions, runcode, openquery, etc.)[/li]
[li]23 additional queries for data display (delete, select, crosstab)[/li]
[li]40 forms (half form, half subform)[/li]
[li]Numerous fuctions[/li][/ul]
Together with my co-worker, we're familiar enough with linkedserver, TSQL, ASP, VB and more. Not real familiar with stored procedures and triggers.

We'd like to head toward a web front end with scheduled and customer-triggered data updates drawn from two SQL 2K linked servers and one Oracle linked server.

References to good starting points for design and implementation considerations and tools is appreciated.

Thank you.


snyderj

 

[SQLSister]

Access upsizing wizard can get you started on upsizing your data to SQL Server. You will want to convert your queries to stored procedures which means learning stored procedure programming and then how to call the stored procedures from your interface. If you are going to have scheduled updates from some outside source, you will need to learn about DTS, and most definitely, you will need to learn about SQL database admin. More later, we are going to dinner now.