[dba-SQLServer]SQL Server Upsize

Dont know LOL But will find out!

Martin


----- Original Message ----- 
From: "Billy Pang" <tuxedo_man at hotmail.com>
To: <dba-sqlserver at databaseadvisors.com>
Sent: Friday, August 08, 2003 1:56 PM
Subject: Re: [dba-SQLServer]SQL Server Upsize


> Is it possible to enforce referential integrity between two tables where
> parent table is in Access and child table is in SQL Server?
>
>
>
> >From: Martin Reid <mwp.reid at qub.ac.uk>
> >Reply-To: dba-sqlserver at databaseadvisors.com
> >To: dba-sqlserver <dba-sqlserver at databaseadvisors.com>
> >Subject: [dba-SQLServer]SQL Server Upsize
> >Date: Fri, 8 Aug 2003 13:37:41 -0700
> >
> >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
> >
>
> _________________________________________________________________
> Protect your PC - get McAfee.com VirusScan Online
> http://clinic.mcafee.com/clinic/ibuy/campaign.asp?cid=3963
>
> _______________________________________________
> dba-SQLServer mailing list
> dba-SQLServer at databaseadvisors.com
> http://databaseadvisors.com/mailman/listinfo/dba-sqlserver
> http://www.databaseadvisors.com
>
>