When I try to migrate any tables from an SQL Server 6.5 database to a
Postgres 7.3 database it fails. Is the problem in PgAdmin II or elsewhere?
I get the following message in the Migration Wizard.
-----------------
Creating table: PPT_Products
An error occured at: 1/23/2003 8:46:39 AM:
-2147217865: Invalid object name 'sysindexkeys'.
Rolling back... Done.
-----------------
Here is the errors/SQL Pgadmin II log:
2003-01-23 08:45:17 - SQL (template1): SELECT version()
2003-01-23 08:45:17 - SQL (template1): SELECT datlastsysoid FROM pg_database
WHERE datname = 'template1'
2003-01-23 08:45:17 - SQL (template1): SELECT oid, datname, datpath,
datallowconn, pg_encoding_to_char(encoding) AS serverencoding,
pg_get_userbyid(datdba) AS datowner FROM pg_database ORDER BY datname
2003-01-23 08:45:17 - SQL (template1): SELECT * FROM pg_group ORDER BY
groname
2003-01-23 08:45:17 - SQL (template1): SELECT * FROM pg_user ORDER BY
usename
2003-01-23 08:45:17 - SQL (template1): SELECT datname, procpid, usename,
current_query FROM pg_stat_activity
2003-01-23 08:46:28 - SQL (ppt_production): SELECT oid, relname,
pg_get_userbyid(relowner) as tableowner, relacl, relhasoids FROM pg_class
WHERE ((relkind = 'r') OR (relkind = 's')) ORDER BY relname
2003-01-23 08:46:39 - SQL (ppt_production): BEGIN
2003-01-23 08:46:39 - SQL (ppt_production): ROLLBACK
-----------------------
here is the psqlodbc log:
conn=55522888, PGAPI_DriverConnect( in)=
'
DRIVER={PostgreSQL};
UID=evans_rick;PWD=********;
SERVER=129.30.159.239;
PORT=5432;
DATABASE=template1;
READONLY=0;PROTOCOL=6.4;
FAKEOIDINDEX=0;
SHOWOIDCOLUMN=0;
ROWVERSIONING=0;
SHOWSYSTEMTABLES=0;
CONNSETTINGS=;
FETCH=100;
SOCKET=4096;
UNKNOWNSIZES=0;
MAXVARCHARSIZE=254;
MAXLONGVARCHARSIZE=65536;
OPTIMIZER=1;
KSQO=1;
USEDECLAREFETCH=0;
TEXTASLONGVARCHAR=1;
UNKNOWNSASLONGVARCHAR=1;
BOOLSASCHAR=1;
PARSE=0;
CANCELASFREESTMT=0;
EXTRASYSTABLEPREFIXES=dd_;
COMMLOG=0;
DEBUG=0;
'
, fDriverCompletion=0
------------------------------------------
