Hi Experts,
Migrating warehouse from Oracle to SQL Server :
Status: In process
In Oracle : 6 Schemas
In SQL Server: Created a database with 6 Schemas.
-Every Schema has 3 Paritioned and 3 non partitioned tables.
-Out of 3 partitioned tables one is parent table and all other 5 tables are child tables.
-Only parent table has date column and non other table has date column for partitioning.
-all the 5 tables in each schema has primary key.
My Question is can I partition parent table with date column and child tables with Primary key column ?
If so please can someone advise the partitioning method for a parent table and child tables.
sometimes the partitioning column in parent table has abnormal dates like 2099,2088. How can i seperate those values. I listened that we can do by MAX and MIN dates while partitioning but not sure how to implement that..
Thanks for all your time.
.
social.technet.microsoft.com/Forums
