Re: RDA - Foreign Key Constraints?

Tech Tip: Click here to run a free scan for Windows Errors and optimize PC performance

From: Darren Shaffer (darrenshaffer_at_discussions.microsoft.com)
Date: 11/21/04

  • Next message: Darren Shaffer: "Re: Possible to create database on desktop?" 
    Date: Sat, 20 Nov 2004 20:44:09 -0700

    I've had to add the FK constraints manually after replication, but lately
    have
    decided FK constraints on the device database aren't really worth the
    trouble.
    I leave the important relational rules enforcement to the server-side
    database and
    minimize problems by enforcing containment/aggregate/associative rules on
    device,
    in my code.

    -Darren Shaffer

    "Steve" <ss_nospam@yahoo.com> wrote in message
    news:6nosp0posni1etk6ogotcqbubin9rh4teu@4ax.com...
    > Should the RDA Pull, with Tracking Indexes On Include Foreign key
    > constraints? Or do I need to use DDL after the pull to establish the
    > fk constraints?
    >
    > I am pulling from a SQL 2000 database with Foreign Key Constraints.
    > All of the indexes are coming across for the pulled tables except for
    > the fk constraints.
    >
    > Is this something that will be addressed with SQL 2005 Mobile?
    >
    >
    > Steve

  • Next message: Darren Shaffer: "Re: Possible to create database on desktop?"

    Relevant Pages

    • Re: A real world example
      ... If a constraint is defined in terms of successive states of a database, ... Yes, that's all facts are, though constraints mean that your facts are ... value of a candidate key determines the values of all other attributes, ... The frame of reference for a candidate key is a ...
      (comp.databases.theory)
    • Re: A real world example
      ... If a constraint is defined in terms of successive states of a database, ... facts cannot be thought of just in terms of instances of predicates. ... Yes, that's all facts are, though constraints mean that your facts are ...
      (comp.databases.theory)
    • Re: A real world example
      ... If a constraint is defined in terms of successive states of a database, ... Yes, that's all facts are, though constraints mean that your facts are ... model already allows surrogate keys. ...
      (comp.databases.theory)
    • Re: A real world example
      ... If a constraint is defined in terms of successive states of a database, ... facts cannot be thought of just in terms of instances of predicates. ... Yes, that's all facts are, though constraints mean that your facts are ... referencing all of the attribute values, nor, given only the key value, ...
      (comp.databases.theory)
    • Re: Declarative constraints in practical terms
      ... It is a portion of one or more software applications, ... The definition of a database should be all that is required to ... Constraints are an integral ... declarative constraints: SQL declarations enforced by a DBMS engine ...
      (comp.databases.theory)