Post reply

SQL Server to MS Access schema export w/ constraints

  • August 15, 2005 at 10:39 am

    #67467

    Hello.

    Can anyone share ther experiences or perhaps make a recommendation on a commercial ap for my problem? 

    Here is the scenario:

    Want to replicate a schema from a set of tables in an SQL Server db into MS Access. Also want to recreate the FK constraints, and the tables used by the constraints.  For example:

    Table XYZ

    Columns:

    ID

    A_CL - constrianed by A_CL.CODE

    B_CL - constrianed by B_CL.CODE

    Data1

    Data2

    Table A_CL

    Columns:

    Code

    Descrip

    Table B_CL

    Columns:

    Code

    Descrip

    I am looking into a DTS package, but not clear how best to approach this.

    Thanks for your assitance and comments,

    -John Chioles

    jchioles AT eprod DOT COM

     

  • August 15, 2005 at 3:47 pm

    #582299

    I think Embarcadero has a number of tools that can help you

  • August 15, 2005 at 10:32 pm

    #582336

    I use Visio for Enterprise Architects that comes with Visual Studio for Enterprise Architects (VERSION 6, 2002, or 2003).

    It has the ability to reverse engineer an existing database and convert most features to a different target database, including SQL Server, Oracle, Access, etc., by actually creating the database or my favorite scripts that can be checked into SourceSafe.

    It does not support SQL Server 2000 functions or defaults, to my dismay.

    As well as creating a good graphic depiction of the data model and unlike Access or SQL Server the data model can be easily Printed. I use 11x17 paper to print my models, which make developers really happy.

    Andy

Viewing 3 posts - 1 through 3 (of 3 total)

You must be logged in to reply to this topic. Login to reply