DevForce Community Forum : Copying/Cloning models between SQL Instances http://www.ideablade.com/forum/ This is an XML content feed of; DevForce Community Forum : DevForce Classic : Copying/Cloning models between SQL Instances Mon, 13 Apr 2026 06:46:18 -700 Fri, 14 Mar 2008 11:15:37 -700 http://blogs.law.harvard.edu/tech/rss Web Wiz Forums 9.69 360 www.ideablade.com/forum/RSS_post_feed.asp?TID=600 DevForce Community Forum http://www.ideablade.com/forum/forum_images/IdeaBlade_logo_tm.png http://www.ideablade.com/forum/ Copying/Cloning models between SQL Instances : Has this been resolved. I am wanting... http://www.ideablade.com/forum/forum_posts.asp?TID=600&PID=2695#2695 Author: orcities
Subject: 600
Posted: 14-Mar-2008 at 11:15am

Has this been resolved. I am wanting the same thing. A clone of the object and all of it's references.]]> Fri, 14 Mar 2008 11:15:37 -700 http://www.ideablade.com/forum/forum_posts.asp?TID=600&PID=2695#2695 Copying/Cloning models between SQL Instances : I have this same code sample (from... http://www.ideablade.com/forum/forum_posts.asp?TID=600&PID=2201#2201 Author: PJones
Subject: 600
Posted: 13-Dec-2007 at 9:35am

I have this same code sample (from tech support) already.
 
When you say "handles" foreign keys what do you mean?
 
What I want is the object and its entire dependent tree including all data in all child objects cloned.  This code only clones the target object and skips all relations downward and makes an exact copy of foreign key values which will not always work (ie. if I clone a patternCollection child of a Project class I don't want it to be the child of Project 1 (cloned) but the child of the newly created (cloned) Project object).
 
Pete
]]> Thu, 13 Dec 2007 09:35:44 -700 http://www.ideablade.com/forum/forum_posts.asp?TID=600&PID=2201#2201 Copying/Cloning models between SQL Instances : Here is some sample code for cloning.... http://www.ideablade.com/forum/forum_posts.asp?TID=600&PID=2169#2169 Author: davidklitzke
Subject: 600
Posted: 12-Dec-2007 at 8:34am

Here is some sample code for cloning.  It handles such problems as:
 
o A cloned object cannot have a primary key identical to the object from which it is being cloned.
o Handling of foreign keys
 
uploads/20071212_113325_EntityCloner.zip
]]> Wed, 12 Dec 2007 08:34:02 -700 http://www.ideablade.com/forum/forum_posts.asp?TID=600&PID=2169#2169 Copying/Cloning models between SQL Instances : I have a need to read an object... http://www.ideablade.com/forum/forum_posts.asp?TID=600&PID=2155#2155 Author: PJones
Subject: 600
Posted: 11-Dec-2007 at 10:30am

I have a need to read an object model from one SQL (remote) database and persist that model to another SQL (local) database.  I also need to be able to push the local DB info back to the remote.
 
Are there any built-in features and/or best practices for accomplishing this?
 
 
]]> Tue, 11 Dec 2007 10:30:32 -700 http://www.ideablade.com/forum/forum_posts.asp?TID=600&PID=2155#2155