SQLTeam.com | Weblogs | Forums

How to Refresh all tables only From PRD to Test database


#1

Hello,

I wanted to know is there a way to refresh data only from Production to Test?

I have SQL server 2012.

Thanks,


#2

By "data only", I assume you meant that you don't want to backup and restore the database to the test environment. You can use import/export wizard to export data from the production tables to the dev environment.


#3

Yes, data only. Import/Export wizard OK. I will try it.