lundi 28 décembre 2015

Can anyone suggest the best way to move a database from SQL Server 2008 to 2005?

I have database with a size of around 100GB in SQL Server 2008. I want to run this database in SQL Server 2005. Can anyone suggest the best way to move that database from SQL Server 2008 to 2005?

I have generated a script using the generate script wizard. The script file is around 25 GB large. So I ran the script from the command prompt using this command:

Sqlcmd -U sa -P **** -S 192.168.10.001\SQL2005 
       -i D:\dbRestore\Script.sql -a 32767 
       -o D:\dbRestore\ScriptError.txt

And I got the following errors:

Unclosed quotation mark after the character string

Cannot insert explicit value for identity column in table 'xxx' when IDENTITY_INSERT is set to OFF

Invalid object name 'data_set'

Invalid column name 'benefit_contract_id'

Cannot assign a default value to a local variable.

Must declare the scalar variable

Cannot use TEXTIMAGE_ON when a table has no text, ntext, image, varchar(max), nvarchar(max), varbinary(max), xml or large user defined type columns.

User or role 'tuser01' does not exist in this database.
Windows NT user or group 'xxx\SQL_QA' not found. Check the name again

Can anyone help me to solve these issues?

Aucun commentaire:

Enregistrer un commentaire