APEX version is 4.1.1.
Is it possible to export only the team development data from workspace X on server A to workspace X on server B? The workspaces have the same name, and I don't want to drop and recreate the workspace on server B (I will lose all users and links to applications this way, correct?).
What did you try?
I guess you're interested in the Feedback from Test / Prod and want to feed it back into your Dev environment...
That's exactly the purpose of this tool. Just go to Export and Select the Feedback tab (far right). Export it and import it in Dev...
I'm not talking about the team feedback... I meant the whole Team Development environment, so this includes all tasks, to dos, milestones etc. There's a way to export that information together with the workspace, but when I try to import that file into another server which already has a workspace with the same name, the error "Workspace will not be created because it already exists." is thrown...
Yes there is. In the application builder, when you press export you get the option to export the workspace. With the workspace users and workspace info like schemas are exported, but also you have the option to export the team development data.
After the export you can open the sql file and you will see near the beginning:
The xxxx is your workspace_id, you can find this in the Apex schema of your database in the Apex_Workspaces view. You need to change this to the workspace_id of your new database. If you created your workspace by exporting or by copying these ids should already be the same, but check just to be sure.
Lastly you might want to search the file and see if nothing unwanted is created. For example:
wwv_flow_fnd_user_api.create_fnd_user ( ... );
Is PL/SQL to create a user , you could remove that if you don't want the user to be created/edited.