Post reply

Import/Export Triggers from pgsql to MSSql server 2005

  • February 9, 2009 at 9:46 pm

    #130796

    Hi

    I have a db on postgre sql I am trying to export this db to sql server 2005 I could do this by back up and recovery technique. I could import all the tables but I am unable to import/take back up of triggers,view, indices and stored proc's. can any body help in getting them on to my mssql db(rather than writing them afresh).

    thanks in advance

    Raveens

  • February 9, 2009 at 9:51 pm

    #940952

    your views and indexes should port right over, but triggers,procedures and functions will need to be hand edited; there just isn't an easy way to move those over, sorry.

    Are you doing all of them and they all fail as a group, or did you try to move views separately for example?

    Lowell

    --help us help you! If you post a question, make sure you include a CREATE TABLE... statement and INSERT INTO... statement into that table to give the volunteers here representative data. with your description of the problem, we can provide a tested, verifiable solution to your question! asking the question the right way gets you a tested answer the fastest way possible!

  • February 9, 2009 at 10:24 pm

    #940965

    Please don't cross post.

    You have to write this again.

    Follow me on Twitter: http://www.twitter.com/way0utwest
    Forum Etiquette: How to post data/code on a forum to get the best help
    My Blog: www.voiceofthedba.com

Viewing 3 posts - 1 through 2 (of 2 total)

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