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

Re: 'Import' scripted DB ?

Path	csiph.com!v102.xanadu-bbs.net!xanadu-bbs.net!feeder.erje.net!us.feeder.erje.net!newsfeed.fsmpi.rwth-aachen.de!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 10:55:11 +0200
Organization	Erland Sommarskog
Lines	36
Message-ID	<XnsA38B6F1513E6AYazorman@127.0.0.1> (permalink)
References	<53eee78b$0$23648$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="21992"; mail-complaints-to="abuse@eternal-september.org"; posting-account="U2FsdGVkX1/wpmBiJDDq2u7MbotAGfxX"
User-Agent	Xnews/2006.08.24 Mime-proxy/2.1.c.0 (Win32)
Cancel-Lock	sha1:ERA1m8GRKzv05OEqFKbrbqCNHSo=
Xref	csiph.com comp.databases.ms-sqlserver:1788

Show key headers only | View raw

Mads Aggerholm (mads001@xxxxxhotmail.com) writes:
> I am about to move a DB from a 10.50.1600 MS SQL Server to a 10.0.1600 
> Server.

That's the RTM version of both SQL 2008 and SQL 2008 R2. Don't you believe 
in service packs?

> Backup the SB and restoring in the new place is impossible, since the 
> version does not 'fit'. I did already try setting it to 'Level 90', but 
> no luck.

That's right. You cannot restore a backup from a higher version of SQL 
Server on a lower version.

> I scriptet the whole thing, including data, and got a large file, about 
> one Gbyte.
> This is far too big for the MS SQL Server to handle.

It's far too big for SQL Server Management Studio. Whether it is too
big for the engine is a moot question, since the engine will never
see the full script, only the batches.

> On the internet i forund this:
> sqlcmd -S xxx.xxx.xxx.xxx -i C:\SQLFOLDER\database.sql -o
> 
> Unfortunately, it does not work.

What does "it does not work" mean? I seem to recall that I have been
able to load very large files with SQLCMD, at least with the 64-bit 
version of SQLCMD.

But else, try a third-party product for your situaton, like Red Gate's
SQL Compare. (There is an evaluation license for 14 days, I seem to recall.)

-- 
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