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

Re: 'Import' scripted DB ?

Path	csiph.com!usenet.pasdenom.info!aioe.org!eternal-september.org!feeder.eternal-september.org!news.eternal-september.org!.POSTED!not-for-mail
From	Erland Sommarskog <esquel@sommarskog.se>
Newsgroups	comp.databases.ms-sqlserver
Subject	Re: 'Import' scripted DB ?
Date	Sat, 16 Aug 2014 21:42:39 +0200
Organization	Erland Sommarskog
Lines	36
Message-ID	<XnsA38BDCDB39B2BYazorman@127.0.0.1> (permalink)
References	<53eee78b$0$23648$edfadb0f@dtext02.news.tele.dk> <XnsA38B6F1513E6AYazorman@127.0.0.1> <53ef9675$0$23649$edfadb0f@dtext02.news.tele.dk>
Mime-Version	1.0
Content-Type	text/plain; charset=windows-1252
Content-Transfer-Encoding	8bit
Injection-Info	mx05.eternal-september.org; posting-host="944e8a95b2bfa5abbf0e792f87734688"; logging-data="14529"; mail-complaints-to="abuse@eternal-september.org"; posting-account="U2FsdGVkX18RCHkfPWtjZn07veXEx5F+"
User-Agent	Xnews/2006.08.24 Mime-proxy/2.1.c.0 (Win32)
Cancel-Lock	sha1:BYxAw/m/sW3n90EwPouMBof0n50=
Xref	csiph.com comp.databases.ms-sqlserver:1790

Show key headers only | 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