[TriLUG] transferring database contents
robdale at gmail.com
Sun Jun 20 09:09:13 EDT 2010
Take a look at SQuirrel SQL. You could also use DBCopy (within
squirrel) to copy straight to postgresql.
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?
> 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
More information about the TriLUG