home bbs files messages ]

Forums before death by AOL, social media and spammers... "We can't have nice things"

   comp.databases.ms-sqlserver      Notorious Rube Goldberg contraption      19,505 messages   

[   << oldest   |   < older   |   list   |   newer >   |   newest >>   ]

   Message 19,091 of 19,505   
   Erland Sommarskog to Mads Aggerholm   
   Re: 'Import' scripted DB ?   
   16 Aug 14 21:42:39   
   
   From: esquel@sommarskog.se   
      
   Mads Aggerholm (mads001@xxxxxhotmail.com) writes:   
   > That's beyound my influence. It's for some customer, who will not upgrade.   
      
   Idiots!   
      
   >>> On the internet i forund this:   
   >>> sqlcmd -S xxx.xxx.xxx.xxx -i C:\SQLFOLDER\database.sql -o   
   >>>   
   >>> Unfortunately, it does not work.   
   >   
   > First, it says: "Sqlcmd: '-o': Missing argument. Enter '-?' for help."   
      
   Yes, -o takes an argument. This option redirects the output to a file.   
      
   > Then I type '-?', and get the message: "'-?' is not regoqnized as an   
   > internal or external command, operable program or batch file."   
      
   You are supposed to type   
      
      sqlcmd -?   
      
   You can also find information about the command options to SQLCMD in Books   
   Online.   
      
   > Well, I ommit the '-o' and tries without it:   
   >   
   > If waits for some seconds, then says:   
   > "HResult 0x2, Level 16, State 1 Named Pipes Provider: Could not open a   
   > connection to SQL Server [2].   
      
   So you did not specify the name of the instance correctly. This is no   
   different from how you do it in SSMS. It has nothing to do with the size   
   of your scripts.   
      
   --   
   Erland Sommarskog, Stockholm, esquel@sommarskog.se   
      
   --- SoupGate-Win32 v1.05   
    * Origin: you cannot sedate... all the things you hate (1:229/2)   

[   << oldest   |   < older   |   list   |   newer >   |   newest >>   ]


(c) 1994,  bbs@darkrealms.ca