To get MS into a PG database I had to use the MS-SQL Enterprise Manager that allowed me to "Script the Database". This made some non SQL92/99 compliant scripts for the schema of the database that I then had to edit to work with my PG install (7.2.x). Then I used some VBScript code to connect to both databases and drag the data across. I hated every minute of it. It was not very efficient but it did get the job done. Every time I see a post like this it reminds me to work on this code I started that would create the necessary PgSQL Schema code from an MS-SQL DB.
/B ----- Original Message ----- From: "nate" <[EMAIL PROTECTED]> To: <[EMAIL PROTECTED]> Sent: Tuesday, March 18, 2003 13:22 Subject: Re: Backup MS SQL Database > Jason M. Kuhlman said: > > Is it possible to backup a MS SQL database to one of the open source RDBMS > > like SAPDB, PostGreSQL, or MySQL? If so how? > > really don't think so. but the MS SQL admin interface has a tool that > allows you to dump the database to a text file, which can easily be > backed up. Not sure what the tool is called since I've never used MS SQL > but one of my co workers did and thats what he did for backups. > > similar to mysqldump. > > nate > > > > > > -- > redhat-list mailing list > unsubscribe mailto:[EMAIL PROTECTED] > https://listman.redhat.com/mailman/listinfo/redhat-list -- redhat-list mailing list unsubscribe mailto:[EMAIL PROTECTED] https://listman.redhat.com/mailman/listinfo/redhat-list
