This discussion is archived
1 Reply Latest reply: Jun 29, 2013 4:05 AM by mkirtley-Oracle Branched from an earlier discussion. RSS

Re: Sql server migration to oracle -Sample vs actual dump

JayanthKumarGS Newbie
Currently Being Moderated

Hello Mike,

 

I'm trying the same Hesh did, the credentials and connection info is given right but not able to proceed further.

 

OMWB_OFFLINE_CAPTURE sa sa-password <db-name on sqlserver> server_name ( where the SQL SERVER is running)

 

but gives me error as below I'm not sure what i am missing.

 

 

'bcp' is not recognized as an internal or external command,

operable program or batch file.

'bcp' is not recognized as an internal or external command,

operable program or batch file.

'bcp' is not recognized as an internal or external command,

operable program or batch file.

'bcp' is not recognized as an internal or external command,

operable program or batch file.

'bcp' is not recognized as an internal or external command,

operable program or batch file.

'bcp' is not recognized as an internal or external command,

operable program or batch file.

'bcp' is not recognized as an internal or external command,

operable program or batch file.

'bcp' is not recognized as an internal or external command,

operable program or batch file.

'bcp' is not recognized as an internal or external command,

operable program or batch file.

'bcp' is not recognized as an internal or external command,

operable program or batch file.

'bcp' is not recognized as an internal or external command,

operable program or batch file.

'bcp' is not recognized as an internal or external command,

operable program or batch file.

'bcp' is not recognized as an internal or external command,

operable program or batch file.

'bcp' is not recognized as an internal or external command,

operable program or batch file.

'bcp' is not recognized as an internal or external command,

operable program or batch file.

'bcp' is not recognized as an internal or external command,

operable program or batch file.

'bcp' is not recognized as an internal or external command,

operable program or batch file.

'bcp' is not recognized as an internal or external command,

operable program or batch file.

'isql' is not recognized as an internal or external command,

operable program or batch file.

'bcp' is not recognized as an internal or external command,

operable program or batch file.

'isql' is not recognized as an internal or external command,

operable program or batch file.

** ERROR pubs\SS7_SYSUSERS.DAT has not been created. Please check the screen output and .err files to detect t

he problem. Execute the script again when the problem is fixed or contact your Oracle representative if the pr

oblem persists.

** ERROR pubs\SS7_SYSPERMISSIONS.DAT has not been created. Please check the screen output and .err files to de

tect the problem. Execute the script again when the problem is fixed or contact your Oracle representative if

the problem persists.

** ERROR pubs\SS7_SYSPROTECTS.DAT has not been created. Please check the screen output and .err files to detec

t the problem. Execute the script again when the problem is fixed or contact your Oracle representative if the

problem persists.

** ERROR pubs\SS7_SYSOBJECTS.DAT has not been created. Please check the screen output and .err files to detect

the problem. Execute the script again when the problem is fixed or contact your Oracle representative if the

problem persists.

** ERROR pubs\SS7_SYSCOLUMNS.DAT has not been created. Please check the screen output and .err files to detect

the problem. Execute the script again when the problem is fixed or contact your Oracle representative if the

problem persists.

** ERROR pubs\SS7_SYSTYPES.DAT has not been created. Please check the screen output and .err files to detect t

he problem. Execute the script again when the problem is fixed or contact your Oracle representative if the pr

oblem persists.

** ERROR pubs\SS7_SYSINDEXKEYS.DAT has not been created. Please check the screen output and .err files to dete

ct the problem. Execute the script again when the problem is fixed or contact your Oracle representative if th

e problem persists.

** ERROR pubs\SS7_SYSREFERENCES.DAT has not been created. Please check the screen output and .err files to det

ect the problem. Execute the script again when the problem is fixed or contact your Oracle representative if t

he problem persists.

** ERROR pubs\SS7_SYSCONSTRAINTS.DAT has not been created. Please check the screen output and .err files to de

tect the problem. Execute the script again when the problem is fixed or contact your Oracle representative if

the problem persists.

** ERROR pubs\SS7_SYSCOMMENTS.DAT has not been created. Please check the screen output and .err files to detec

t the problem. Execute the script again when the problem is fixed or contact your Oracle representative if the

problem persists.

** ERROR pubs\SS7_SYSFILES.DAT has not been created. Please check the screen output and .err files to detect t

he problem. Execute the script again when the problem is fixed or contact your Oracle representative if the pr

oblem persists.

** ERROR pubs\SS7_SYSMEMBERS.DAT has not been created. Please check the screen output and .err files to detect

the problem. Execute the script again when the problem is fixed or contact your Oracle representative if the

problem persists.

** ERROR pubs\SS7_SYSFOREIGNKEYS.DAT has not been created. Please check the screen output and .err files to de

tect the problem. Execute the script again when the problem is fixed or contact your Oracle representative if

the problem persists.

** ERROR pubs\SS7_SYSINDEXES.DAT has not been created. Please check the screen output and .err files to detect

the problem. Execute the script again when the problem is fixed or contact your Oracle representative if the

problem persists.

** ERROR master\SS7_SYSLOGINS.DAT has not been created. Please check the screen output and .err files to detec

t the problem. Execute the script again when the problem is fixed or contact your Oracle representative if the

problem persists.

** ERROR master\SS7_SYSDATABASES.DAT has not been created. Please check the screen output and .err files to de

tect the problem. Execute the script again when the problem is fixed or contact your Oracle representative if

the problem persists.

** ERROR master\SS7_SYSDATABASES.DAT has not been created. Please check the screen output and .err files to de

tect the problem. Execute the script again when the problem is fixed or contact your Oracle representative if

the problem persists.

'bcp' is not recognized as an internal or external command,

operable program or batch file.

'isql' is not recognized as an internal or external command,

operable program or batch file.

**************************************************************************

** The offline capture script has completed execution.

** Please review the screen output and .err files (if any) in the output

** directories for any irregularities. You may need to execute the

** script again to resolve any irregularities.

**

** Finally, please archive the directory with sqlserver7.ocp file in it.

** This contains the master and pubs directories (preserve the

** directory structure in the archive) the ROW.TXT, the COLUMN.TXT, and the

** sqlserver7.ocp file and return the archive file to

** your Oracle representative.

  • 1. Re: Sql server migration to oracle -Sample vs actual dump
    mkirtley-Oracle Expert
    Currently Being Moderated

    Hi,

      The 'bcp' utility is a Microsoft program and the error is saying that it is not available to the user that is running the offline script.
    On my Windows machine it is in the directories -
    C:\Program Files\Microsoft SQL Server\100\Tools\Binn
    C:\Program Files\Microsoft SQL Server\80\Tools\Binn

     

    You should check the location on the machine where you are running the script and make sure the directory is in the PATH variable for the user running the script.
    If you issue the bcp command from the command line you will see output like this -

    C:\Documents and Settings\mkirtley>bcp

    usage: bcp {dbtable | query} {in | out | queryout | format} datafile

      [-m maxerrors]            [-f formatfile]          [-e errfile]

      [-F firstrow]             [-L lastrow]             [-b batchsize]

      [-n native type]          [-c character type]      [-w wide character type]

      [-N keep non-text native] [-V file format version] [-q quoted identifier]

      [-C code page specifier]  [-t field terminator]    [-r row terminator]

      [-i inputfile]            [-o outfile]             [-a packetsize]

      [-S server name]          [-U username]            [-P password]

      [-T trusted connection]   [-v version]             [-R regional enable]

      [-k keep null values]     [-E keep identity values]

      [-h "load hints"]

     

    By the way, it is always better to open a new thread for problems instead of adding to an older thread. Sometimes the updates to old threads can be missed or ignored.

     

    Regards,
    Mike