How can we help you today? How can we help you today?
gahuja
Activity overview Badges (0) Posts (13) Comments (7)

Comments

Sort by recent activity
e..g CREATE TABLE staging.rg_temp_318261722_1 ( cob_date DATE NOT NULL, run_id NUMBER(*,0) NOT NULL, processing_location VARCHAR2(3 BYTE) NOT NULL, trial_balance_id NUMBER(25) NOT NULL, freq_ind CHAR, "ADJ_DATE" DATE, source_ref VARCHAR2(56 BYTE), native_currency VARCHAR2(3 BYTE), expiry_date DATE, key_pos_17 CHAR DEFAULT '_', key_pos_18 CHAR DEFAULT '_', CREATE TABLE control.d_trade_bkp ( cob_date DATE NOT NULL, run_id NUMBER(*,0) NOT NULL, processing_location VARCHAR2(3 BYTE) NOT NULL, trial_balance_id NUMBER(25) NOT NULL, freq_ind CHAR, IN botht he cases the dataype of run_id is integer which gets converted to NUMBER(*,0) Need to know why tool is doing this / comments
  1. Community
  2. Schema Compare for Oracle
  3. Integer datatype shown as number(*,0) in deploymnt script ?
e..g CREATE TABLE staging.rg_temp_318261722_1 ( cob_date DATE NOT NULL, run_id NUMBER(*,0) NOT NULL, processing_location VARCHAR2(3 BYTE) NOT NULL, trial_balance_id NUMBER(25) NOT NULL, freq_ind CH...
0 votes
Hi Richard may be you are talking of the stage when we deploy the script we get the deployment warnings but I would like to have only the warnings without deploring the script so that i can work on the warnings before hand even before trying to deploy the script is it possible to have the warnings before deploying Thanks Gagan / comments
  1. Community
  2. Schema Compare for Oracle
  3. How to get Warning Report with Command line interface?
Hi Richard may be you are talking of the stage when we deploy the script we get the deployment warnings but I would like to have only the warnings without deploring the script so that i can work on...
0 votes
Hi Richard when is the next version expected to release? Thanks Gagan / comments
  1. Community
  2. Schema Compare for Oracle
  3. How to get Warning Report with Command line interface?
Hi Richard when is the next version expected to release? Thanks Gagan
0 votes
Hi Phil Below error is coming all the time creating schema comparison HTML simple report from GUI and command line,please help '.',hexadecimal value 0x07,is an invalid character Please see complete log below C:Program FilesRed GateSchema Compare for Oracle 3sco32" -source star_ro_user/STAR_RO_USER@qnyb3r70{WEB} -target star_ro_user/STAR_RO_USER@DNYB3R10{WEB} /report:"M:Report_WEB.html" -reporttype:Simple /script-file "M:Script_WEB.sql" -behavior script-header -behavior define-off Schema Compare for Oracle: activated, edition: standard, serial number:XXXXXXXXXX Schemas found WEB Schemas found in Target WEB Checking that DataSources can be parsed Checking Source star_ro_user/STAR_RO_USER@qnyb3r70 can be parsed Parsing datasource string star_ro_user/STAR_RO_USER@qnyb3r70 Split DataSource into 3 components star_ro_user | STAR_RO_USER | qnyb3r70 DataSource star_ro_user/STAR_RO_USER@qnyb3r70 is a TNS Connection Looking for TNS name qnyb3r70 in Oracle home OraHome112_32 No TNS Entry for qnyb3r70 found, trying to connect using Oracle home OraHome112_32 Connection String = Data Source=qnyb3r70;User Id=star_ro_user;Password=STAR_RO_USER;Connection Timeout=60;Pooling=false;Unicode=true; Checking Target star_ro_user/STAR_RO_USER@DNYB3R10 can be parsed Parsing datasource string star_ro_user/STAR_RO_USER@DNYB3R10 Split DataSource into 3 components star_ro_user | STAR_RO_USER | DNYB3R10 DataSource star_ro_user/STAR_RO_USER@DNYB3R10 is a TNS Connection Looking for TNS name DNYB3R10 in Oracle home OraHome112_32 No TNS Entry for DNYB3R10 found, trying to connect using Oracle home OraHome112_32 Connection String = Data Source=DNYB3R10;User Id=star_ro_user;Password=STAR_RO_USER;Connection Timeout=60;Pooling=false;Unicode=true; Reading dependency information Registering database one Registering database two Comparing databases Found 1061 differences Generating report Error: '', hexadecimal value 0x07, is an invalid character. Use -? for help / comments
  1. Community
  2. Schema Compare for Oracle
  3. Blank Schema comparison HTML reports through command line
Hi Phil Below error is coming all the time creating schema comparison HTML simple report from GUI and command line,please help'.',hexadecimal value 0x07,is an invalid character Please see complete ...
0 votes
Hello Now I'm getting the below error which I get while doing comparison from the GUI also alll the time also the HTML report generated now is not blank but failed with below error Also please confirm that without /deploy switch I'll not be able to create deployment script? I repeat I don't want to deply the changes but only want the HTML report and deployment script to be created "C:Program FilesRed GateSchema Compare for Oracle 3sco32" -source star_ro_user/STAR_RO_USER@qnyb3r70{WEB} -target star_ro_user/STAR_RO_USER@DNYB3R10{WEB} /report:"M:Report_WEB.html" -reporttype:Simple /script-file "M:Script_WEB.sql" -behavior script-header -behavior define-off Schema Compare for Oracle: activated, edition: standard, serial number: XXXXXXXXXXXXXXXXX Schemas found WEB Schemas found in Target WEB Checking that DataSources can be parsed Checking Source star_ro_user/STAR_RO_USER@qnyb3r70 can be parsed Parsing datasource string star_ro_user/STAR_RO_USER@qnyb3r70 Split DataSource into 3 components star_ro_user | STAR_RO_USER | qnyb3r70 DataSource star_ro_user/STAR_RO_USER@qnyb3r70 is a TNS Connection Looking for TNS name qnyb3r70 in Oracle home OraHome112_32 No TNS Entry for qnyb3r70 found, trying to connect using Oracle home OraHome112_32 Connection String = Data Source=qnyb3r70;User Id=star_ro_user;Password=STAR_RO_USER;Connection Timeout=60;Pooling=false;Unicode=true; Checking Target star_ro_user/STAR_RO_USER@DNYB3R10 can be parsed Parsing datasource string star_ro_user/STAR_RO_USER@DNYB3R10 Split DataSource into 3 components star_ro_user | STAR_RO_USER | DNYB3R10 DataSource star_ro_user/STAR_RO_USER@DNYB3R10 is a TNS Connection Looking for TNS name DNYB3R10 in Oracle home OraHome112_32 No TNS Entry for DNYB3R10 found, trying to connect using Oracle home OraHome112_32 Connection String = Data Source=DNYB3R10;User Id=star_ro_user;Password=STAR_RO_USER;Connection Timeout=60;Pooling=false;Unicode=true; Reading dependency information Registering database one Registering database two Comparing databases Found 1061 differences Generating report Error: '', hexadecimal value 0x07, is an invalid character. Use -? for help C:Usersgahuja4> / comments
  1. Community
  2. Schema Compare for Oracle
  3. Blank Schema comparison HTML reports through command line
Hello Now I'm getting the below error which I get while doing comparison from the GUI also alll the time also the HTML report generated now is not blank but failed with below error Also please con...
0 votes
Thanks Phil I'll really appreciate if you can give the timeline by when you will be able to provide the build I'm working on project so need to plan accordingly Thanks Gagan / comments
  1. Community
  2. Schema Compare for Oracle
  3. Blank Schema comparison HTML reports through command line
Thanks Phil I'll really appreciate if you can give the timeline by when you will be able to provide the build I'm working on project so need to plan accordingly Thanks Gagan
0 votes
Hi Richard it worked with SCO32 Many Thanks Gagan / comments
  1. Community
  2. Schema Compare for Oracle
  3. Connection to source/target working GUI but not with cmd lin
Hi Richard it worked with SCO32 Many Thanks Gagan
0 votes
Total activity
24
Last activity
Member since
Following
0 users
Followed by
0 users
Votes
0
Subscriptions
4