I am working on an assignment of migrating a database from SQL 2000 to 2005. That is not a big deal. But at the mean time, there is a huge table contains orders in the database which I want to partition it. In oracle, we can use redefine package to partition an existing table, this won't be an issue. However, this is SQL Server...so I have to determine what is the best practice...
1)migrate the whole db, create a new partitioned order_new table, move the data to the order_new, rename order to order_old, rename order_new to order.
2)migrate the whole db, use scripts(if there is any) to partition the existing order table.
3)migrate the whole db except the order table, create a partition one on the new server, import the data.(the migration might encounter constraint issues, not a good approach)
4)any other ideas?
Subscribe to:
Post Comments (Atom)
Added more to my mindmap tool
This essay version allows you to add long essays to each topic. https://www.free-mindmap.com/Mindmap4LawSchoolEssay.html As I promised, the...
-
This essay version allows you to add long essays to each topic. https://www.free-mindmap.com/Mindmap4LawSchoolEssay.html As I promised, the...
-
prompt ==================================================== prompt == Start of check_cursor.sql prompt ===================================...
-
Which two are true about the Automatic Database Diagnostic Monitor (ADDM)? (Choose two.) A. It analyzes a period of time corresponding to ...
No comments:
Post a Comment