General discussion

  • Creator
    Topic
  • #2343840

    SQL Server Questions

    Locked

    by azelan ·

    When transfering a table from SQL 6.5 to SQL 7, how can i preserve the primary key from the table. Seems that every time i do transfer, all the Primary keys will gone and need to manually set it. How to schedule SQL Server an automated shutdown?

All Comments

  • Author
    Replies
    • #3406416

      SQL Server Questions

      by mattohare ·

      In reply to SQL Server Questions

      I can answer the first question, I believe. If you use the Data Transformation Wizard that comes with SQL Server 7, then you should be able to choose “Transfer Database Objects” on the third page of the wizard. This is the page just after choosingthe destination of the data. This is the only option that transfers all of the data schema in addition to the data itself.

      As far as scheduling an automated shutdown, I think it’s in the pulldown menus of a wizard too, but I dont really know.

      • #3602673

        SQL Server Questions

        by azelan ·

        In reply to SQL Server Questions

        The question was auto-closed by TechRepublic

    • #3397560

      SQL Server Questions

      by maxwell edison ·

      In reply to SQL Server Questions

      http://www.microsoft.com/technet/treeview/default.asp?url=/TechNet/prodtechnol/sql/proddocs/diag/75528frt.asp

      (REMOVE SPACES from the pasted URL.)

      Take a look at the index on the left of the page. I think you may find a chapter to describe a process that may be helpful.

      Maxwell

      • #3602674

        SQL Server Questions

        by azelan ·

        In reply to SQL Server Questions

        The question was auto-closed by TechRepublic

    • #3602672

      SQL Server Questions

      by azelan ·

      In reply to SQL Server Questions

      This question was auto closed due to inactivity

Viewing 2 reply threads