Re: How can i import database from MSSQL to Postgres?(NULL BODY)

From: "Andrew John" <aj(at)DELETEmistrose(dot)com>
To: pgsql-hackers(at)postgresql(dot)org
Subject: Re: How can i import database from MSSQL to Postgres?(NULL BODY)
Date: 2002-11-27 12:15:47
Message-ID: as2cu1$1of9$1@arachne.labyrinth.net.au
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-hackers

David,

Most generic format you can get it out of SQL Server in is CSV
by using a DTS ( Export Data ) wizard to text format. Another
alternative is the bcp command line tool, which produces standardised formats
These are documented in SQL Books Online ( free download from Microsoft )
http://www.microsoft.com/sql/techinfo/productdoc/2000/books.asp

Regards
AJ

"david luo" <davidluo(at)techemail(dot)com> wrote in message news:20021127102442(dot)52A0A487F(at)sitemail(dot)everyone(dot)net(dot)(dot)(dot)
> thanks in advance
>
> _____________________________________________________________
> Are you a Techie? Get Your Free Tech Email Address Now! Visit http://www.TechEmail.com
>
> _____________________________________________________________
> Select your own custom email address for FREE! Get you(at)yourchoice(dot)com w/No Ads, 6MB, POP & more!
http://www.everyone.net/selectmail?campaign=tag
>
> ---------------------------(end of broadcast)---------------------------
> TIP 1: subscribe and unsubscribe commands go to majordomo(at)postgresql(dot)org

In response to

Browse pgsql-hackers by date

  From Date Subject
Next Message Achilleus Mantzios 2002-11-27 12:23:12 FreeBSD, Linux: select, select count(*) performance
Previous Message Hannu Krosing 2002-11-27 10:54:13 Re: [mail] Re: Native Win32 sources