Results 1 to 4 of 4
  1. #1
    Join Date
    Jan 2005
    Posts
    2

    Unanswered: How to migrate Posgress SQL database to Microsoft SQL 2000

    How to migrate Posgress SQL database to Microsoft SQL 2000 with all primary keys and views?

    Is the function in Postgres SQL need to re-code in MSSQL 2000 manually?

  2. #2
    Join Date
    Dec 2004
    Location
    Kharkov, Ukraine
    Posts
    40
    Use Data Transformation Service in MS SQL for migrate tables and data.
    Unfortunately, functions, views need to recode.
    Triggers is a BIG TROUBLE.
    (((

  3. #3
    Join Date
    Jan 2005
    Posts
    2
    Are you mean use data import function in enterprise manager?
    If yes, how to reserve the primary keys from postgres SQL database?

  4. #4
    Join Date
    Jun 2004
    Posts
    57

    Triggers and PK's

    I believe you can generate the primary keys after that if DTS don't preserve them. And I don't believe that views must be rewritten. I don't see any reason for that. The problem is with triggers because in PostGreSQL you use rules. And in SQL Server you don't have triggers before.

Posting Permissions

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