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

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

Re: 'Import' scripted DB ?

Show all headers | 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