Create a copy of a table pointing to a copy of the physical storage for testing

[Roc]

In my companies brillant wisdom we do not have a dev. enviroment. Everytime we have to do a change to a DI job we have to recreate everything over in the job including the tables and load the data to make a test job. Is the anyway to replicate a table along with the physical source using a tool or command? If not I have to basically recreate 200 tables and reload them or quit.

[LinusH]

I sense some irony in your initial statement...
And you frustration is justified in IMO.
So this about both physical and meta data?
I strongly recommend that you urge your company to create development environment. Even if it isn't ideal, it could be on the same server which would mean no extra licensing cost.
By separating the environments you will save time (which means mony), reducing complexity and risk of human errors in the production environment.

That said, you could develop scripts/programs to duplicate and potentially rename data. I think for the metadata part there are possibilities to do some tweaking when using the batch export/import metadata tool.

[Roc]

Thanks for your response. I have a programmer looking into it. It probably
took 3 years to create every job in this business unit and we have a week
to duplicate them all. Crazy.

##- Please type your reply above this line. Simple formatting, no
attachments. -##