SQL/Server via ODBC -> PGSQL?

1,095 registered users | 0 active users | 0 LpH | Statistics
Login | Create New User

Welcome to IWETHEY!

Post #183,364 by broomberg 11/7/04 3:45:56 PM Reply	SQL/Server via ODBC -> PGSQL? I have ODBC access (only) to a SQL/Server database. I want to pull out its table definitions and recreate them under Postgres. Any simple utilities to do this? Sure, I COULD pull the defs by hand, but I'm feeling lazy.
Post #183,368 by broomberg 11/7/04 4:42:24 PM Reply	This looks interesting [link\|http://search.cpan.org/~broom/DBIx-Migrate-0.01/Migrate.pm\|http://search.cpan.o...e-0.01/Migrate.pm] Checkout the name of the home dir! And then look at the author's name. Not even close.
Post #183,371 by broomberg 11/7/04 5:46:41 PM Reply	Never mind I simply connected to the old SQL/Server and the new Postgres instances via ODBC in Access2003, and then exported the tables that way.
Post #183,386 by folkert 11/7/04 6:53:24 PM Reply	I guess access is good enough for SOMETHING -- [link\|mailto:greg@gregfolkert.net\|greg], [link\|http://www.iwethey.org/ed_curry\|REMEMBER ED CURRY!] @ *i_wethey* No matter how much Microsoft supporters whine about how Linux and other operating systems have just as many bugs as their operating systems do, the bottom line is that the serious, gut-wrenching problems happen on Windows, not on Linux, not on Mac OS. -- [link\|http://www.eweek.com/article2/0,1759,1622086,00.asp\|source] Here is an example: [link\|http://www.greymagic.com/security/advisories/gm001-ie/\|Executing arbitrary commands without Active Scripting or ActiveX when using Windows]
Post #183,409 by daemon 11/7/04 9:27:52 PM Reply	good for changing diebold votes that way too many Iraqis conceived of free society as little more than a mosh pit with grenades. ANDISHEH NOURAEE

SQL/Server via ODBC -> PGSQL? - (broomberg) - (4) - Nov. 7, 2004, 03:45:56 PM EST

This looks interesting - (broomberg) - (3) - Nov. 7, 2004, 04:42:24 PM EST

Never mind - (broomberg) - (2) - Nov. 7, 2004, 05:46:41 PM EST

I guess access is good enough for *SOMETHING* -NT - (folkert) - (1) - Nov. 7, 2004, 06:53:24 PM EST

good for changing diebold votes -NT - (daemon) - Nov. 7, 2004, 09:27:52 PM EST

iwethey.org

Running on an Atari 800 with two extra 16KB memory banks.
60 ms