[dba-SQLServer]SQL Server Upsize

Why not move everything to SQL?  It will be highly inefficient to do any
joins using 2 sources, unless taking the join to Access.  This will
definitely be inefficient.

Robert Djabarov
Sr. SQL Server DBA
Phone: (210) 913-3148
Pager: (210) 753-3148


-----Original Message-----
From: dba-sqlserver-bounces at databaseadvisors.com
[mailto:dba-sqlserver-bounces at databaseadvisors.com] On Behalf Of Martin
Reid
Sent: Friday, August 08, 2003 3:38 PM
To: dba-sqlserver
Subject: [dba-SQLServer]SQL Server Upsize


Folks

I am looking at a large Multiple Back End DB. We are converting it to
SQL Server/MSDE

heres is one option. I would like comments pleaseeeeeeeeeee

All data heavy tables will be moved to SQL Server 2000. Other smaller
tables whcih dont actualy contain a great deal of data will remain in
Access MDB. We will then link the whole thing into the Front End. Move
as much processing of this stuff to SQL Server, read only tto Pass
Throughs.

We are not using ADPS becasue of the recoding of the entire system. But
it may be possible as there is a way to run DAO in an ADP.

Anyone see any problems with this approach?

Anyone care to suggest another?

Any major problems joing local MDB linked tables to SQL Server Linked
tables?

Feel free to comment. I want to kick the options around.

Martin

_______________________________________________
dba-SQLServer mailing list
dba-SQLServer at databaseadvisors.com
http://databaseadvisors.com/mailman/listinfo/dba-sqlserver
http://www.databaseadvisors.com