Post reply

BCP and Parent/child tables

  • June 5, 2005 at 4:28 am

    #88645

     

    Hi.......

    I am going to develop a BCP procedure in a large DB SQLServer2000 with more 300 tables.

    Myquestion is :

    Because of Primary Keys and Foreign Keys, there are Parent and childs tables, I cannot run BCP on tables randomly or by alphabetic order , but a correct order to keep the constranits between tables.

    What are the best way to identify on which table must be run first the BCP utility.

    Anyone can suggest me some tools or other utility (eg MS store procedure...) to solve my problem?

    Any help will be appreciated.....

    Thank in advance

     

  • June 6, 2005 at 10:36 am

    #563280

    If you have the VS.NET loaded ( I have MS.NET Framework1.1)

    Open MS.NET , Goto Tools Menu..ConnectToDatabase.. Provide necessary Connection details.. after you comlpete this step..

    Under ServerExplorer properties window.. you will see the Dataconnection just you comlpeted..

    Click on the database that you have connected to..you will see database Diagrams..right click and say New.. You will be prompted with available tables..

    selected tables you want and say OK.

    VS will draw a database diagram with all the Primary and foriegn key, check constraints relationships.. Then you can take a closer look at this diagram to udner stand the order or the sequence in which you are supopsed to load these tables.. i did this for a database havign only 35 tables... so i found it easy.. but if you have 300 or more (like you said).. i don't if this method is for you..

    Please let me know if you found something interesting

    THNQdigital..

     

     

     

     

     

     

     

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

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