info 58414 - Friday, January 20, 2017 2:53 AM

Hi,

We have to migrate a SQL-2008 DBe to SQL 2014. All 300 tables are hosted in primary filegroup.
The new server has a secondary filegroup with multiple files.
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?

Regards
Nicole