Post reply

Import/Export doesn''t copy the Pk

  • December 21, 2005 at 5:39 pm

    #96085

    I tried to import/export tables b/w SQL 2005 servers using SQL Management Studio.  There is no option to include the PK, FKs as SQL 2000 Enterprice Manager did.  Is it somewhere I missed?  Thanks.

  • December 23, 2005 at 9:15 am

    #611324

    I cannot find the option too. But you can change the generated create table script and add the PK or FK. The wizard will execute the code. This is really inconvinent if you are importing lots of tables.

     

     

  • December 23, 2005 at 10:13 am

    #611338

    that is something I really want to include

  • December 28, 2005 at 8:09 am

    #611690

    I think there is already option is there to copy PK's and foreign keys.

    During Import - Export there is a button called Optios if u click that

    This option will come

  • December 28, 2005 at 10:35 am

    #611730

    are you sure there is such button in SQL 2005 Management Studio?  I just looked one more time, there is no such button.

Viewing 5 posts - 1 through 4 (of 4 total)

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