Post reply

Missing PK mark(s)

  • June 4, 2003 at 9:06 am

    #82116

    I transferred SQL7 tables to MS Access for distribution. Everything seems okay, but I found the tables on the destination lost Primary Key mark(s).

    What¡¯s wrong? Any ideas?

    Thank you!

  • June 4, 2003 at 9:16 am

    #459750

    How did the transfer happen?

    Cheers,

    Frank

    --
    Frank Kalis
    Microsoft SQL Server MVP
    Webmaster: http://www.insidesql.org/blogs
    My blog: http://www.insidesql.org/blogs/frankkalis/[/url]

  • June 4, 2003 at 9:27 am

    #459756

    Hi Frank,

    In general, I use DTS Import/Export Wizard to complete this task. You know, it's simple just to point out the source, the destination, and tables. During the transferring, nothing wrong. Is there any way to transfer data with PK marks?

    Thanks

  • June 4, 2003 at 9:31 am

    #459758

    Hi,

    unless I've been mistaken this is normal behaviour.

    Cheers,

    Frank

    --
    Frank Kalis
    Microsoft SQL Server MVP
    Webmaster: http://www.insidesql.org/blogs
    My blog: http://www.insidesql.org/blogs/frankkalis/[/url]

  • June 4, 2003 at 9:55 pm

    #459851

    If u have use DTS Import/Export Wizard and said that create the constraints at destination table it does not create tge constraints using the wizard. If i need to do the same thing then i would have created the script with constarints and create the tables at destination and then would have run the DTS Import/Export wizard

    Regards

    Jay

  • June 14, 2003 at 6:35 pm

    #461428

    Probably missing the point as usual, but since Access and SQl Server have different schemas, is not impossible to copy objects(apart from base) between the two.

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

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