SAS Data Integration Studio, DataFlux Data Management Studio, SAS/ACCESS, SAS Data Loader for Hadoop and others

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

Reply
Occasional Contributor Roc
Occasional Contributor
Posts: 16

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

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.

Super User
Posts: 5,254

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

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.
Data never sleeps
Occasional Contributor Roc
Occasional Contributor
Posts: 16

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

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. -##
Ask a Question
Discussion stats
  • 2 replies
  • 222 views
  • 0 likes
  • 2 in conversation