View Issue Details
ID | Project | Category | View Status | Date Submitted | Last Update |
---|---|---|---|---|---|
0002246 | SymmetricDS | Bug | public | 2015-03-31 16:45 | 2019-04-23 16:57 |
Reporter | natarajan | Assigned To | admin | ||
Priority | urgent | ||||
Status | closed | Resolution | won't fix | ||
Product Version | 3.7.11 | ||||
Summary | 0002246: dbexport is not considering the value mentioned in schema and catalog parameter | ||||
Description | I want to export all the tables from one particular schema which is not same mentioned in the prop file. Below option not working, do you know what is the issue? Thanks dbexport --format=sql --compatible=mysql --engine=corp-000 --schema ctt1 AHI_PMT_HIST --catalog ctt1 Log output will be written to C:\Users\nsunda1\Desktop\jm\MySQL\symmetric-server -3.7.11\symmetric-server-3.7.11/logs/symmetric.log [] - AbstractCommandLauncher - Option: name=format, value={sql} [] - AbstractCommandLauncher - Option: name=compatible, value={mysql} [] - AbstractCommandLauncher - Option: name=engine, value={corp-000} [] - AbstractCommandLauncher - Option: name=schema, value={ctt1} [] - AbstractCommandLauncher - Option: name=catalog, value={ctt1} [] - JdbcDatabasePlatformFactory - Detected database 'Oracle', version '10', pro tocol 'oracle' [] - JdbcDatabasePlatformFactory - The IDatabasePlatform being used is org.jumpm ind.db.platform.oracle.OracleDatabasePlatform ------------------------------------------------------------------------------- An exception occurred. Please see the following for details: ------------------------------------------------------------------------------- java.lang.RuntimeException: Cannot find table AHI_PMT_HIST in catalog ctt1 and s chema ctt1 at org.jumpmind.symmetric.io.data.DbExport.exportTables(DbExport.java:14 5) at org.jumpmind.symmetric.DbExportCommand.executeWithOptions(DbExportCom mand.java:192) at org.jumpmind.symmetric.AbstractCommandLauncher.execute(AbstractComman dLauncher.java:190) at org.jumpmind.symmetric.DbExportCommand.main(DbExportCommand.java:75) ------------------------------------------------------------------------------- C:\Users\nsunda1\Desktop\jm\MySQL\symmetric-server-3.7.11\symmetric-server-3.7.1 1\bin> | ||||
Tags | No tags attached. | ||||
|
Use catalog and/or schema as required by database platform. Oracle expects only schema to be used, while MySQL expects only catalog to be used. https://www.symmetricds.org/doc/3.7/html/user-guide.html#_catalog_and_schema |