[TriLUG] transferring database contents

[Robert Dale]

Take a look at SQuirrel SQL. You could also use DBCopy (within
squirrel) to copy straight to postgresql.
http://squirrel-sql.sourceforge.net

-- 
Robert Dale


On Sun, Jun 20, 2010 at 7:54 AM, Brian McCullough <bdmc at bdmcc-us.com> wrote:
> Although this starts off not connected with Linux, I am trying to get to a Linux system with this.
>
> I know that this group has a lot of varied knowledge and experience, so here's the question of the day.
>
>
> I am in the process of preparing for a project which involves transferring from SQL Server to PostreSQL.  It was suggested that I download a copy of SQL Server Express from M$' website, and so I did and installed it in a new VM of mine.  I was also given a "backup" of the SQL Server database, which is of some binary format, which SSExpress is happy to read.
>
> However, I can't seem to find a way to export the structure and data in a portable fashion, preferably as SQL statements.  If I could get such a thing, I am sure that, despite differences in SQL syntax, I could convert such a thing into a usable form.
>
> Does such a method exist with this database engine?
>
>
> Thanks,
> Brian
>
>
> --
> This message was sent to: Robert Dale <robdale at gmail.com>
> To unsubscribe, send a blank message to trilug-leave at trilug.org from that address.
> TriLUG mailing list : http://www.trilug.org/mailman/listinfo/trilug
> Unsubscribe or edit options on the web  : http://www.trilug.org/mailman/options/trilug/robdale%40gmail.com
> TriLUG FAQ          : http://www.trilug.org/wiki/Frequently_Asked_Questions
>