We have to migrate a SQL-2008 DB to SQL 2014. All 300 tables are hosted in primary filegroup.
The new server has a secondary filegroup with multiple files - laying on a fusion-IO.
Can i restore a backup from old server to the new server into the secondary filegroup? (Upgrade advisor is done)
Or, have i to move the tables manually from primary to secondary (over clustered index).
Or, create a empty Target-DB with (Insert into new table - Select from old table) for all 300 tables ?
What is the most effective way to do this?
Or are there helping tools to do a lot of this work?