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

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

'Import' scripted DB ?

Show all headers | View raw

Hello!

I am about to move a DB from a 10.50.1600 MS SQL Server to a 10.0.1600 
Server.
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.
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.

On the internet i forund this:
sqlcmd -S xxx.xxx.xxx.xxx -i C:\SQLFOLDER\database.sql -o

Unfortunately, it does not work.

So, I scripted it all again, but this time I asked it to split it up, 
one file per table/Procedure/function/etc.
I believe it will work, but now I have a lot of files and don't know 
which one to do first.
The names are like:
##MS_PolicyEventProcessingLogin##.Login.sql
##MS_PolicyTsqlExecutionLogin##.Login.sql
Conv.Schema.sql
<usernam>-dbr.sql
<databasename>.Database.sql

I wonder if there could be some kind of control, where it is possible to 
tell the system something like:
'All scripts for the database is in this folder, go import everything in 
the right order.'

Does anyone have a good advice?

Sincerely/Best regards
Mads Aggerholm

Back to comp.databases.ms-sqlserver | Previous | Next — 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