Groups | Search | Server Info | Keyboard shortcuts | Login | Register [http] [https] [nntp] [nntps]

Groups > comp.databases.ms-sqlserver > #1790

Re: 'Import' scripted DB ?

Show all headers | View raw

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

Back to comp.databases.ms-sqlserver | Previous | Next — Previous in thread | Next in thread | Find similar

Thread

'Import' scripted DB ? Mads Aggerholm <mads001@xxxxxhotmail.com> - 2014-08-16 07:09 +0200
  Re: 'Import' scripted DB ? Erland Sommarskog <esquel@sommarskog.se> - 2014-08-16 10:55 +0200
    Re: 'Import' scripted DB ? Mads Aggerholm <mads001@xxxxxhotmail.com> - 2014-08-16 19:36 +0200
      Re: 'Import' scripted DB ? Erland Sommarskog <esquel@sommarskog.se> - 2014-08-16 21:42 +0200
        Re: 'Import' scripted DB ? Mads Aggerholm <mads001@xxxxxhotmail.com> - 2014-08-17 20:13 +0200
          Re: 'Import' scripted DB ? Erland Sommarskog <esquel@sommarskog.se> - 2014-08-17 20:45 +0200
            Re: 'Import' scripted DB ? Ross Presser <rpresser@gmail.com> - 2014-08-22 08:58 -0700
      Re: 'Import' scripted DB ? Lutz <news@invalid.invalid> - 2014-08-18 11:29 +0200
        Re: 'Import' scripted DB ? Erland Sommarskog <esquel@sommarskog.se> - 2014-08-18 10:49 +0000
          Re: 'Import' scripted DB ? Ross Presser <rpresser@gmail.com> - 2014-08-22 08:56 -0700

csiph-web