Professional Web Applications Themes

Two database cooperate - Microsoft SQL / MS SQL Server

There are two database on SQL Server, Database1 and Database2. All tables on these two database are same. No primary key, index and relationship between tables is defined on Database1, but there are much record had inserted to it. The primary key, index and relationship are defined on Database2. I want to apply these primary key, index and relationships on Database2 to Database1 by create an application such as ..Net or VB. How should I do? Thanks!...

  1. #1

    Default Two database cooperate

    There are two database on SQL Server, Database1 and Database2.

    All tables on these two database are same. No primary key, index and
    relationship between tables is defined on Database1, but there are much
    record had inserted to it. The primary key, index and relationship are
    defined on Database2. I want to apply these primary key, index and
    relationships on Database2 to Database1 by create an application such as
    ..Net or VB.

    How should I do?

    Thanks!




    wolf Guest

  2. #2

    Default Re: Two database cooperate

    You can script out all the Indexes and the constraints from one of the
    database and apply the same on the other ... Use the Enterprise manager to
    script out the Indexes and constraints for you ...

    --
    HTH,
    Vinod Kumar
    MCSE, DBA, MCAD
    www.extremeexperts.com


    "wolf" <com> wrote in message
    news:phx.gbl... 


    Vinodk Guest

  3. #3

    Default Re: Two database cooperate

    I had forgot something to say. Our client not allow us to create the
    script from the Enterprise manager. Because this progress is a function
    of my application, the developer do not know the detail of the two
    database so that they can not get the script, and the client should only
    run the application to complete this task.

    "Vinodk" <com> 写入消息新闻
    :phx.gbl... 



    wolf Guest

Similar Threads

  1. Cant get DataSet and RDBMSResolver to cooperate
    By sleggaman in forum Macromedia Flash Data Integration
    Replies: 0
    Last Post: April 11th, 06:02 PM
  2. Read Point of Sale database and update server database
    By turtle in forum Macromedia ColdFusion
    Replies: 4
    Last Post: July 20th, 09:41 PM
  3. Replies: 2
    Last Post: September 16th, 10:30 AM
  4. Replies: 2
    Last Post: July 14th, 05:30 PM
  5. Replies: 4
    Last Post: July 1st, 06:01 AM

Bookmarks

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •  

1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24 25 26 27 28 29 30 31 32 33 34 35 36 37 38 39 40 41 42 43 44 45 46 47 48 49 50 51 52 53 54 55 56 57 58 59 60 61 62 63 64 65 66 67 68 69 70 71 72 73 74 75 76 77 78 79 80 81 82 83 84 85 86 87 88 89 90 91 92 93 94 95 96 97 98 99 100 101 102 103 104 105 106 107 108 109 110 111 112 113 114 115 116 117 118 119 120 121 122 123 124 125 126 127 128 129 130 131 132 133 134 135 136 137 138 139