we run Microsoft SQL Server 2008 R2 on production server. We need create new tables and load a big amount of data on them (roughly 1 TB!)
I am wondering if it is possible to insert this dataset on a second test database server to avoid overloading the production server.
Once completed i would like to move the newly create tables in the production db in a "clever" way, avoiding to perform again the inserts.
What do you suggest? For instance, Is it possible to load the new dataset on separate filegroup and then move the files to the production db?