From: esquel@sommarskog.se   
      
   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   
      
   --- SoupGate-Win32 v1.05   
    * Origin: you cannot sedate... all the things you hate (1:229/2)