11/5/2026 10:32:29 PM
|
| |
| slxdeveloper.com Community Forums |
|
| |
|
|
The Forums on slxdeveloper.com are now retired. The forum archive will remain available for the time being. Thank you for your participation on slxdeveloper.com!
Forum to discuss SQL Server or Oracle database administration related to SalesLogix databases. View the code of conduct for posting guidelines.
|
|
|
|
Copy Data from Production Server to Dev server (Oracle)
Posted: 06 Apr 10 5:35 AM
|
Hi All
Having issues with CLOB fields, or not being able to copy them from live to dev db.
What I wish to achieve is to have a PSQL script or similar (maybe sql plus), that essentially copies the contents of the live database to the dev database, but not the system configuration, so that I don't need to reconfigure the entire SLX setup each time I want to baseline my dev/test db.
PSQL copy between instances using SQL Developer works fine unless there is a CLOB field in the table def
Anyone got any info, suggestions or tools that will do the job? Remember FullCopy? that sort of thing would be great! 
Many Thanks in anticipation
Gary
(PS Am SLX Sysadmin but don't have full permissions on Oracle DB, have to involve central dba admin people for some stuff) |
|
|
|
You can
subscribe to receive a daily forum digest in your
user profile. View the site code
of conduct for posting guidelines.
 Forum RSS Feed - Subscribe to the forum RSS feed to keep on top of the latest forum activity!
|
|
|
|
|
|
|
|