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.
Không có nhận xét nào :
Đăng nhận xét