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!

Administration Forums - Database Administration
Forum to discuss SQL Server or Oracle database administration related to SalesLogix databases. View the code of conduct for posting guidelines.

Forums RSS Feed

Back to Forum List | Back to Database Administration | New Thread

View: Search:

Author

Thread: Copy Data from Production Server to Dev server (Oracle)

Gary Jeffery
Posts: 9

Copy Data from Production Server to Dev server (Oracle) Your last visit to this thread was on 1/1/1970 12:00:00 AM

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)

[Reply][Quote]

Page 1 of 1

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!

slxdeveloper.com is brought to you courtesy of Ryan Farley & Customer FX Corporation. This site, and all contents herein, are Copyright © 2024 Customer FX Corporation. The information and opinions expressed here are not endorsed by Sage Software.	code of conduct \|

page cache (param): 4/19/2024 5:02:39 AM