Thứ Sáu, 28 tháng 11, 2014

SQL Server: Chuyển database từ một phiên bản cao hơn sang phiên bản thấp hơn

Tham khảo:

Do keep in mind, of course, that this is probably not a practical option with a large database.  When I've had to do this with 5-10GB DBs, especially when I know I'll be doing it more than once (data coming in from an external site that running a newer version of SQL than we are), I use a variation of this plus SSIS, as follows:
1.  Generate the DB scripts as above, schema only.
2.  Create the empty database.
3.  Use the "Import/Export" commands to import data from the newer version DB into the older one.  Save the SSIS package thus generated.
4.  You may need to modify the default column mappings; for instance, if there are columns of the timestamp datatype, those can't actually be moved over this way.