[dba-SQLServer]SQL Server Upsize

Martin Reid mwp.reid at qub.ac.uk
Fri Aug 8 16:55:04 CDT 2003


At the moment I have everything in SQL Server. Just looking at options at
the moment.

All tables linked in.

Martin

----- Original Message ----- 
From: "Djabarov, Robert" <Robert.Djabarov at usaa.com>
To: "dba-sqlserver" <dba-sqlserver at databaseadvisors.com>
Sent: Friday, August 08, 2003 2:09 PM
Subject: RE: [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
>
> _______________________________________________
> dba-SQLServer mailing list
> dba-SQLServer at databaseadvisors.com
> http://databaseadvisors.com/mailman/listinfo/dba-sqlserver
> http://www.databaseadvisors.com
>
>



More information about the dba-SQLServer mailing list