Forum Stats

  • 3,872,750 Users
  • 2,266,468 Discussions
  • 7,911,293 Comments

Discussions

Unable to Import Access Database using Migration Workbench

I am running a simple test importing an Access 2007 MDB. I use the Migration Workbench to generate the SQL/XML files. However, when I create a project and select the SQL file as the source, it reports that the one table in the MDB is invalid, but provides no error messages. This is a very simple test with a single table which includes 2 columns. The output from the migration is listed below. Any guidance would be greatly appreciated. Thank you.

-----------------------------------------------

REM This SQL script was generated by the Oracle Migration Workbench
REM Exporter for Microsoft Access on 8/5/2009 11:36:12 AM
REM Release: 10.2.0.2.0
REM Version: Microsoft Access 2007
REM Do not modify this file as any modification will invalidate the export
REM and subsequent migration of your Microsoft Access database

set define off
set verify off
set serveroutput on size 1000000
set feedback off
WHENEVER SQLERROR EXIT SQL.SQLCODE ROLLBACK

begin

WWV_MIG_ACC_LOAD.INS_WWV_MIG_ACCESS (
p_dbid => 1,
p_dbname => 'eaton',
p_dbsize => '229KB',
p_dbpathname => 'C:\Documents and Settings\jritsche\My Documents\eaton.mdb',
p_dbuser => 'eaton',
p_dbpassword => ' ',
p_isappdb => 1,
p_isattacheddb => 0,
p_convertdb => 1,
p_jetversion => 4.0,
p_accessversion => 'MS Access 2000',
p_build => 211,
p_collatingorder => 1033,
p_querytimeout => 60,
p_startupform => NULL,
p_startupshowstatusbar => 0
);

end;
/


begin

WWV_MIG_ACC_LOAD.INS_WWV_MIG_ACC_TABLES (
p_dbid => 1,
p_tblid => 1,
p_tblname => 'Product',
p_primarykey => 1,
p_cnvtablestruct => 1,
p_cnvmovedata => 1,
p_cnvri => 1,
p_cnvvalidation => 1,
p_cnvdefault => 1,
p_cnvaddtimestamp => 1,
p_attachtablebacktoaccess => 1,
p_savepassword => 0,
p_cnvmakeupdateable => 1,
p_retainlocalcopy => 0,
p_syncwithserver => 1,
p_ownerid => 1,
p_validationtext => ' ',
p_validationrule => ' ',
p_numberofrows => 2,
p_cachingtable => 0,
p_description => ' ',
p_attributes => 0,
p_conflicttable => NULL,
p_datecreated => '20090731084209',
p_lastupdated => '20090731084417',
p_recordcount => 2,
p_orderbyon => 1,
p_replicafilter => NULL,
p_sourcetablename => ' ',
p_updatable => 0
);

end;
/

begin

WWV_MIG_ACC_LOAD.INS_WWV_MIG_ACC_COLUMNS (
p_dbid => 1,
p_colid => 1,
p_tblid => 1,
p_colname => 'ID',
p_coltype => 4,
p_coltypedesc => 'Long',
p_colautoincr => 1,
p_nextcountervalue => 0,
p_maxlengthsource => 0,
p_avglengthsource => 0,
p_coltextsize => 4,
p_allowzerolength => 0,
p_defaultvalue => ' ',
p_colrequired => 1,
p_colcollatingorder => 1033,
p_colordposition => 1,
p_validationrule => ' ',
p_validationtext => ' ',
p_columndescription => ' ',
p_columnhidden => 1,
p_columnorder => 1,
p_columnwidth => '-1',
p_decimalplaces => 0,
p_foreignname => ' ',
p_validateonset => 1
);

end;
/

begin

WWV_MIG_ACC_LOAD.INS_WWV_MIG_ACC_COLUMNS (
p_dbid => 1,
p_colid => 2,
p_tblid => 1,
p_colname => 'Product_Name',
p_coltype => 10,
p_coltypedesc => 'Text',
p_colautoincr => 0,
p_nextcountervalue => 0,
p_maxlengthsource => 0,
p_avglengthsource => 0,
p_coltextsize => 255,
p_allowzerolength => -1,
p_defaultvalue => ' ',
p_colrequired => 1,
p_colcollatingorder => 1033,
p_colordposition => 2,
p_validationrule => ' ',
p_validationtext => ' ',
p_columndescription => ' ',
p_columnhidden => 1,
p_columnorder => 2,
p_columnwidth => '-1',
p_decimalplaces => 0,
p_foreignname => ' ',
p_validateonset => 1
);

end;
/

begin

WWV_MIG_ACC_LOAD.INS_WWV_MIG_ACC_COLUMNS (
p_dbid => 1,
p_colid => 3,
p_tblid => 1,
p_colname => 'Description',
p_coltype => 10,
p_coltypedesc => 'Text',
p_colautoincr => 0,
p_nextcountervalue => 0,
p_maxlengthsource => 0,
p_avglengthsource => 0,
p_coltextsize => 255,
p_allowzerolength => -1,
p_defaultvalue => ' ',
p_colrequired => 1,
p_colcollatingorder => 1033,
p_colordposition => 3,
p_validationrule => ' ',
p_validationtext => ' ',
p_columndescription => ' ',
p_columnhidden => 1,
p_columnorder => 3,
p_columnwidth => '-1',
p_decimalplaces => 0,
p_foreignname => ' ',
p_validateonset => 1
);

end;
/


begin

WWV_MIG_ACC_LOAD.INS_WWV_MIG_ACC_INDEXES (
p_dbid => 1,
p_indid => 1,
p_tblid => 1,
p_indname => 'PK_Product',
p_cnvindex => 1,
p_isprimary => 1,
p_isunique => 1,
p_isforeign => 0,
p_ignorenulls => 0,
p_isrequired => 1,
p_distinctcount => 2,
p_isclustered => 0
);

end;
/

begin

WWV_MIG_ACC_LOAD.INS_WWV_MIG_ACC_IDX_COLS (
p_dbid => 1,
p_indcolid => 1,
p_indid => 1,
p_colid => 1,
p_colorder => 1,
p_tblid => 1,
p_colname => 'ID'
);

end;
/

begin

WWV_MIG_ACC_LOAD.INS_WWV_MIG_ACC_TAB_PERM (
p_dbid => 1,
p_tblid => 1,
p_userid => 1,
p_permissionid => 1,
p_permission => 1048319,
p_permission_desc => ' DB_SEC_CREATE DB_SEC_FULLACCESS DB_SEC_DELETE DB_SEC_READSEC DB_SEC_WRITESEC DB_SEC_WRITEOWNER DB_SEC_FRMRPT_READDEF DB_SEC_FRMRPT_WRITEDEF DB_SEC_MAC_READDEF DB_SEC_MAC_WRITEDEF DB_SEC_MAC_EXECUTE DB_SEC_MOD_READDEF DB_SEC_MOD_WRITEDEF '
);

end;
/

begin

WWV_MIG_ACC_LOAD.INS_WWV_MIG_ACC_GROUPS (
p_dbid => 1,
p_groupid => 1,
p_grpname => 'Admins'
);

end;
/

begin

WWV_MIG_ACC_LOAD.INS_WWV_MIG_ACC_GROUPS (
p_dbid => 1,
p_groupid => 2,
p_grpname => 'Users'
);

end;
/

begin

WWV_MIG_ACC_LOAD.INS_WWV_MIG_ACC_USERS (
p_dbid => 1,
p_userid => 1,
p_username => 'admin'
);

end;
/


begin

WWV_MIG_ACC_LOAD.INS_WWV_MIG_ACC_GRPSMEMBERS (
p_dbid => 1,
p_grpmbrid => 1,
p_userid => 1,
p_groupid => 1
);

end;
/

begin

WWV_MIG_ACC_LOAD.INS_WWV_MIG_ACC_GRPSMEMBERS (
p_dbid => 1,
p_grpmbrid => 2,
p_userid => 1,
p_groupid => 2
);

end;
/
This discussion has been closed.