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.
Yes, we've done this before as well. Just create a new database from one of your impresario back-ups. I would loop in your IT department prior to dropping your entire database onto a locally hosted computer (unless you are that person). They may have concerns with the security of that machine.
Yep, what Emily says is spot on. If it's a laptop destination, there's a slew of HIPPA and security to untangle.
I would suggest doing this in your own environment and then providing the consultants with a VPN. We’ve done this in the past when working with Tessitura Consultants (we’re self-hosted).