Has anyone ever download the whole database (or selected table) to a local SQL server? I have a consultant who wants to help with cleaning our database and would like to test and build scripts in a local SQL server, so that the database can be refreshed at will. Looking to see if anyone has taken this route before?
Are you on RAMP or locally hosted?
RAMP. The consultant will work in a completely separate SQL environment.