2 Replies Latest reply on Oct 14, 2013 3:19 PM by Bill Robinson

    script export DB by bladelogic

      Hi,

      I need to adapt a script sql 2000 on a sql2008 r2.

      It 'a simple script to export db. I made the necessary changes, it does not work.

      I launched sequels and launched through work while BladeLogic me back:

      Sqlcmd: ': \ patchcedacriexport \ cedacrioutput.txt "-Qselect * from General': Unexpected argument. Enter '-?' for help.


      I am attaching the script sql200 and the same for sql2008.


      Do you have any solution for me?

      thanks

       

      sql2000

       

      set -a

      echo nexec 10.77.188.133 cmd /c osql.exe -E s52dbced.ced.it\\svl -dpatchcedacri -oc:\\temp\\cedacrioutput.txt -Q\"select \* from generale\" -s\; -w3500 -h-1

      nexec 10.77.188.133 cmd /c osql.exe -E -Ss52dbced.ced.it\\svl -dpatchcedacri -w3500 -h-1 -oc:\\temp\\cedacrioutput.txt -Q\"select \* from generale\" -s\;


      sql2008


      echo nexec 10.100.1.200 cmd /c sqlcmd -E in01cp1c-9.ced.it\\cns99p4s -dpatchcedacri -op:\\PatchCedacriexport\\cedacrioutput.txt -Q\"select \* from dbo.generale\" -s\; -w3500 -h-1

      nexec 10.100.1.200 cmd /c sqlcmd -E -Sin01cp1c-9.ced.it\\cns99p4s -dpatchcedacri -w3500 -h-1 -o\"p:\\patchcedacriexport\\cedacrioutput.txt\" -Q\"select \* from generale\" -s\;