topic Create a copy of a table pointing to a copy of the physical storage for testing in SAS Data Management https://communities.sas.com/t5/SAS-Data-Management/Create-a-copy-of-a-table-pointing-to-a-copy-of-the-physical/m-p/253231#M6862 <P>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.</P> Mon, 29 Feb 2016 17:58:08 GMT Roc 2016-02-29T17:58:08Z Create a copy of a table pointing to a copy of the physical storage for testing https://communities.sas.com/t5/SAS-Data-Management/Create-a-copy-of-a-table-pointing-to-a-copy-of-the-physical/m-p/253231#M6862 <P>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.</P> Mon, 29 Feb 2016 17:58:08 GMT https://communities.sas.com/t5/SAS-Data-Management/Create-a-copy-of-a-table-pointing-to-a-copy-of-the-physical/m-p/253231#M6862 Roc 2016-02-29T17:58:08Z Re: Create a copy of a table pointing to a copy of the physical storage for testing https://communities.sas.com/t5/SAS-Data-Management/Create-a-copy-of-a-table-pointing-to-a-copy-of-the-physical/m-p/253270#M6865 I sense some irony in your initial statement...<BR />And you frustration is justified in IMO.<BR />So this about both physical and meta data?<BR />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. <BR />By separating the environments you will save time (which means mony), reducing complexity and risk of human errors in the production environment. <BR /><BR />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. Mon, 29 Feb 2016 20:19:04 GMT https://communities.sas.com/t5/SAS-Data-Management/Create-a-copy-of-a-table-pointing-to-a-copy-of-the-physical/m-p/253270#M6865 LinusH 2016-02-29T20:19:04Z Re: Create a copy of a table pointing to a copy of the physical storage for testing https://communities.sas.com/t5/SAS-Data-Management/Create-a-copy-of-a-table-pointing-to-a-copy-of-the-physical/m-p/253277#M6866 Thanks for your response. I have a programmer looking into it. It probably<BR />took 3 years to create every job in this business unit and we have a week<BR />to duplicate them all. Crazy.<BR /><BR />##- Please type your reply above this line. Simple formatting, no<BR />attachments. -## Mon, 29 Feb 2016 20:34:32 GMT https://communities.sas.com/t5/SAS-Data-Management/Create-a-copy-of-a-table-pointing-to-a-copy-of-the-physical/m-p/253277#M6866 Roc 2016-02-29T20:34:32Z