Why are you migrating individual workbooks, rather than simply taking a backup of your 9.3 server, then using tabadmin restore --no-config to restore it to the new server? If you do that, all your content and all your comments will be moved automatically.
The current 9.3 Tableau server is a dedicated for our project. But 10.4 Tableau server is shared across our organisations, so there are many other projects running on it.
"tabadmin restore" documentation says it will overwrite all the content on the server. So i believe we cannot use this option as we have other projects running on 10.4 Tableau server. Or is there an option to selectively migrate workbooks somehow?
1 of 1 people found this helpful
Ah, I see. Yes, you definitely don't want to overwrite everything else. There is Site Export / Import which may be a better option, but you'll want to read through the documentation carefully.
You might be able to use the REST API to automatically create new comments on the new server based on what was on the old server, with some addition to the text so you could preserve the original commenter and date/time the comment was created. It'd be a little ugly, but it'd work, I think. Edit: You'd have to do this manually, there's no method for doing this automatically
Other than that, the only way I know of to migrate comments would be to directly insert them into the appropriate database locations in the new postgreSQL database. Doing that would be a lot of work, completely unsupported, easy to screw up, and could break the server you are trying to do it on. So, don't do that!
Thank you for your time and suggestion.
You are right we will not risk updating the Tableau Database directly.
We are planning to work around to this problem by doing following:
1. Connect to the Tableau 9.3 underlying Database and export all the comments in a CSV file.
2. In Tableau 10.4 create a new view of Archived comments with in our migrated workbook and have its Datasource pointing to the CSV extracted.
Our users wont be very happy with this workaround but cannot think of a better solution right now.
I do wish Tableau could provide a better solution for this in future.