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?
In TIM, you can create a new instance of impresario. This is an excellent way to do things that are public training facing, but it takes a lot of work to structurally set-up.
Thanks, Troy.
I don't need a public facing as this is more about building scripts. I want to try to keep it simple as well if possible.
Is is possible to do a back up of the database in SQL and then restore it on our local and separate SSMS?
If you look up Live-to-Test copy scripts you should find most of what you want.