Hi Experts,
Project: Datawarehouse migration from Oracle to SQL Server 2012
In Oracle
Number of Schemas in Oracle - 6
Tables: Each Schema has 3 partitioned tables and three unpartitioned tables
Every schema has its own Table space, all non partitioned tables are in its own Table Space
Every partitioned table(three tables in each schema) is partitioned on date partition column. i.each year a new partition is added to that table
(PART_2011, PART_2012, PART_2013 ...etc)
In SQL Server 2012
All schemas from oracle are migrated to SQL Server in to one database with seperate schema name
Number of Schemas:6
Tables: Each Schema has 3 partitioned tables and three unpartitioned tables
My Question: Can you please suggest me how to plan the file groups and partitions in SQL Server like FILEGROUPS for each schema or FILEGROUPS for every year
Let me know if you need more info