AnsweredAssumed Answered

Best practice for copying tables from one SQL server to another

Question asked by jasonarnold2721 on May 7, 2015
Latest reply on Mar 3, 2016 by nancy_kenney

There are probably several ways to to do this but I was wondering what the simplest approach is. I am in the process of creating a data warehouse and will need to move entire tables from one database to anther on a nightly basis. Depending on performance I may simply want to drop the tables from the DW then upload fresh copies or append the rows nightly if I have to. What would be the best overall process configuration to accomplish this?

 

Thanks!

Outcomes