ice_cube210
VIP Member
Hi List,
I am using SQL Server 2000 as my database , I needed to copy my current production data to my CRP data. Whats the best way to do this. JDE has some report R98403 to Copy Business Data from Data Source to another. I tried this once but it dint really give me any results. has any one used this
In SQL server I can restore the last backup of my PD data to overwrite my PY data...but it keeps the owners of the objects as those of PD. ie. my tables owners will be PRODDTA and PRODCTL instead of CRPDTA and CRPCTL.
Will this cause any problems....my users security records use the JDE user..so i guess..they shud still be able to access the data fine..?
How can i change this in SQL....any shortcuts..or will i have to change it for each table one at a time
Any suggestions..thanks in advance
I am using SQL Server 2000 as my database , I needed to copy my current production data to my CRP data. Whats the best way to do this. JDE has some report R98403 to Copy Business Data from Data Source to another. I tried this once but it dint really give me any results. has any one used this
In SQL server I can restore the last backup of my PD data to overwrite my PY data...but it keeps the owners of the objects as those of PD. ie. my tables owners will be PRODDTA and PRODCTL instead of CRPDTA and CRPCTL.
Will this cause any problems....my users security records use the JDE user..so i guess..they shud still be able to access the data fine..?
How can i change this in SQL....any shortcuts..or will i have to change it for each table one at a time
Any suggestions..thanks in advance