Post reply

How to build a SQL Server DB from a Postgre DB using Perl script

  • June 25, 2004 at 3:00 pm

    #85831

    We have a db running on Postgre. And we have a Perl script for creating the Postgre DB, creating the tables and populate the data.

    Now we want to move the DB to SQL Server. I am sitting in front of the Perl script, thinking of changing the psql script to osql script. I was wondering if anyone has done this before and if this is the right approach. I am new to Perl and osql. Any advice will be greatly appreciated!

  • June 25, 2004 at 5:16 pm

    #512063

    As long as you followed general syntax of SQL 92 wihout using extended DDL for Postgre then it should be as simple as point to the SQL drivers. However I am no PERL expert but you will find things a bit easier if you post your code (with security info changed) so folks know what you are working with.

  • July 6, 2004 at 5:47 am

    #513448

    why not to use DTS ... it will be more simple (from SQL Server) ?


    Alamir Mohamed
    Alamir_mohamed@yahoo.com

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

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