Is it compulsory to have table partioned for switch operation?
Yes
Is it possible to migrate data from partitioned table to unpartitioned table on different file group?
1. Switch out the data to the temp table first.
2. Use the ALTER TABLE .. MOVE command to move this table into a different file group
Can I use same partition function and scheme for another table to partitioned if one already exists?
Yes. Both of them will be on the same policy, though you will have to be careful, because alteration in the scheme would have impact on both.
SQLEnthusiast
http://sqlsimplified.com/
Please click the
Mark as Answer button if a post solves your problem!
