How to change datastore for job in BODS

[Former Member]

Hi All,

I am quite new to BODS.

I want to ask can we change table datastore/source in jobs.

I have jobs to execute in BODS.
previously it was working on test now I want to move jobs in Prod.
means now this jobs should run on prod tables. (Table names in both Test and Prod are same)

Is there any shortcut for same?

[Former Member · Accepted solution]

I found a solution.
Simply I will import separate table in prod.

Then by using "Schema Remapping" I will change all schema's

[Former Member]

Right click > edit > change the connection. You cannot change the name of the datastore though.

[former_member202087]

Are you migrating the jobs to a different production server?  If so, I think the approach is to keep the datastore name identical between dev and production.  The first time you migrate the code to production migrate the datastore (and underlying tables) and change the configuration on the Prod datasttore to point to the production environment.

After that first migration you can move objects (new tables, etc) and exclude the datastore so as not to modify the production configuration.