User Profile

Collapse

Profile Sidebar

Collapse
newnauk
newnauk
Last Activity: Aug 25 '10, 12:22 AM
Joined: Aug 20 '10
Location:
  •  
  • Time
  • Show
  • Source
Clear All
new posts
  • newnauk
    started a topic How to mintain ref integrity when you change the primary keys?
    in C Sharp

    How to mintain ref integrity when you change the primary keys?

    I've creatd an ADO.NET app that reads from an MS Access database and I like to modify the primary keys of all the data tables before copying them over to another DB server. When you change the primary keys on a parent table what is the best way to to update the referential integrity to the related child table?

    Thanks,

    Andrew
    See more | Go to post
    • newnauk
      started a topic A better way to clone and update a table to MS Access?
      in C Sharp

      A better way to clone and update a table to MS Access?

      Hello,

      I have written an app that does a deep clone copy from an MS Access database, migrates and inserts the data to another.

      The following is my current implementation:
      ..........
      1. I'm using the strongly typed DataSet classes code-gened by VS2008 when you add an OleDb (MS Access) data source.
      2. "DestDataSe t" and SrcDataSet share the same schema.
      ..........
      Code:
      private
      ...
      See more | Go to post
      No activity results to display
      Show More
      Working...