DevForce Community Forum : Cocktail can support copying between databases? http://www.ideablade.com/forum/ This is an XML content feed of; DevForce Community Forum : Community Forum : Cocktail can support copying between databases? Mon, 22 Jun 2026 19:14:42 -700 Wed, 06 Feb 2013 06:02:50 -700 http://blogs.law.harvard.edu/tech/rss Web Wiz Forums 9.69 360 www.ideablade.com/forum/RSS_post_feed.asp?TID=3977 DevForce Community Forum http://www.ideablade.com/forum/forum_images/IdeaBlade_logo_tm.png http://www.ideablade.com/forum/ Cocktail can support copying between databases? : We have a whole chapteron... http://www.ideablade.com/forum/forum_posts.asp?TID=3977&PID=15813#15813 Author: mgood
Subject: 3977
Posted: 06-Feb-2013 at 6:02am

We have a whole chapter on building dynamic queries on our DRC that provides the foundation for a QueryBuilder.
 
http://drc.ideablade.com/devforce-2012/bin/view/Documentation/dynamic-queries
]]> Wed, 06 Feb 2013 06:02:50 -700 http://www.ideablade.com/forum/forum_posts.asp?TID=3977&PID=15813#15813 Cocktail can support copying between databases? : I currently deals with the... http://www.ideablade.com/forum/forum_posts.asp?TID=3977&PID=15811#15811 Author: giotis
Subject: 3977
Posted: 06-Feb-2013 at 4:47am

     I currently deals with the construction of a QueryBuilder, any help?


Edited by giotis - 06-Feb-2013 at 1:52pm]]> Wed, 06 Feb 2013 04:47:38 -700 http://www.ideablade.com/forum/forum_posts.asp?TID=3977&PID=15811#15811 Cocktail can support copying between databases? : giotis,You are asking for consulting... http://www.ideablade.com/forum/forum_posts.asp?TID=3977&PID=15807#15807 Author: mgood
Subject: 3977
Posted: 05-Feb-2013 at 8:12pm

giotis,
You are asking for consulting advice that goes beyond product feature support. Using DevForce/Cocktail for the purpose of copying data from one database to another is quite unorthodox and not a feature of the product as such. Please understand that we have a consulting team for these kinds of questions as outlined in the rules of engagement post. I'll gladly answer questions about specific features of Cocktail/DevForce in this forum, but for further advise on how to implement a feature like this, I have to refer you to our consulting organization. 

http://www.ideablade.com/forum/forum_posts.asp?TID=3772&title=please-read-rules-of-engagement


Edited by mgood - 05-Feb-2013 at 8:14pm]]> Tue, 05 Feb 2013 20:12:37 -700 http://www.ideablade.com/forum/forum_posts.asp?TID=3977&PID=15807#15807 Cocktail can support copying between databases? : something like this ? public... http://www.ideablade.com/forum/forum_posts.asp?TID=3977&PID=15805#15805 Author: giotis
Subject: 3977
Posted: 05-Feb-2013 at 2:54pm

something like this ?

      

public CopyDataViewModel(IResourceMgtUnitOfWork UnitOfWork)    {

            IGlobalCache globalCache = new GlobalCache(SecondManagerProvider);
            IResourceMgtUnitOfWork uow = new ResourceMgtUnitOfWork(SecondManagerProvider, globalCache);

            var items = UnitOfWork.StaffingResource.AllAsync();
 
            .... and after ?
            .... How can do the copying?
           

        }

        [Export]
        public IEntityManagerProvider<TempHireEntities> SecondManagerProvider    {
            get   {
                var provider = new EntityManagerProvider<TempHireEntities>();
                provider.Configure(config => config.WithConnectionOptions(ConnectionOptions.Second.Name));
                return provider;
            }
        }


Edited by giotis - 05-Feb-2013 at 2:58pm]]> Tue, 05 Feb 2013 14:54:15 -700 http://www.ideablade.com/forum/forum_posts.asp?TID=3977&PID=15805#15805 Cocktail can support copying between databases? : I&#039;m assuming that the sample... http://www.ideablade.com/forum/forum_posts.asp?TID=3977&PID=15803#15803 Author: mgood
Subject: 3977
Posted: 05-Feb-2013 at 2:26pm

I'm assuming that the sample you refer to uses two EntityManagers with different datasource extensions to connect to different databases and then queries the data from the first EM adds it to the second EM and saves. 

First of all that's about the most inefficient way of copying data. That's a huge overhead just to copy data. You better handle this at the database level.

Anyway, if you want to do it this way, you just create two EntityManagerProviders with different ConnectionOptions.
]]> Tue, 05 Feb 2013 14:26:39 -700 http://www.ideablade.com/forum/forum_posts.asp?TID=3977&PID=15803#15803 Cocktail can support copying between databases? : I know that IdeaBlade supports... http://www.ideablade.com/forum/forum_posts.asp?TID=3977&PID=15800#15800 Author: giotis
Subject: 3977
Posted: 05-Feb-2013 at 2:10pm

I know that IdeaBlade supports copying between two databases, (I have see the sample)
can be done this under cocktail and how?

many thanks]]> Tue, 05 Feb 2013 14:10:50 -700 http://www.ideablade.com/forum/forum_posts.asp?TID=3977&PID=15800#15800