I am also looking to do this, so any suggestions would be greatly appreciated
We don't really have this kind of methodology in place in our Server environment at Tableau, so I don't feel like I can advise much on any best practices in trying to implement it, specifically. There was a decent discussion on this a little bit ago that you can find here, though.
In terms of moving and transforming content between Tableau Server instances, there are a few options. The Enterprise Deployment Tool by Interworks is the best thing I have seen to try and meet this need so far, but I have not used it extensively (to date I have only moved around 20 workbooks / datasources with it). I would recommend checking it out.
You can also script your own solutions that use tabcmd get to download content from a Server instance, hack the XML of the workbook/datasource files to point to the appropriate databases / Tableau Server instances, then tabcmd publish to push them to the next Server instance in the cycle. Scheduled refreshes don't come over, the owner of the workbook becomes whatever account was used to run the script, permissions on the other side will just inherit the Project defaults if they're net-new, and all the views will be published, regardless of what views may not have been published on the "from" Server. Those caveats apply to the Enterprise Deployment Tool too, though (at least as of v1.6).
Lastly, you can simply hand-publish the workbooks from server to server, editing connections in Desktop then publishing to the new server. A little harder when you're referencing published Data Sources, but still doable. Not a lot of fun, though.
If anyone's really solved this problem, it'd be great to put up a doc about it, as it is a common question.
Hi Vivek - The short answer is that Tableau doesn't have an automated / easy way to promote through dev/test/prod. The theory is that with a tool intended to be self service, this kind of promotion scenario isn't required.
BUT - I do understand that this is simply not true in some business environments and you are required to follow the standard dev/dest/prod process for all sorts of reasons.
The usual answer is to check out InterWork's Power Tools for Tableau mentioned by Matt - they are a Tableau Gold Partner and it's probably the best solution for a traditional promotion process out there currently.
There are plenty of other discussions about this on the forum and if you're happy with a less traditional approach, you may find some useful processes out there. Here's one of the other ongoing discussions - How best to develop and then promote dashboards on Tableau Server