Re: [Treebase-devel] db2->pg data transfer

[Hilmar L. <hl...@du...>]

This sounds great! -hilmar

On May 28, 2009, at 5:10 PM, Mark Dominus wrote:

> Rutger, Val and I just had a meeting in which we decided on a plan for
> how to do this.
>
> Either Rutger or I will write a program that dumps out the database
> tables as a series of SQL 'insert' commands.  We will be responsible  
> for
> making sure that the data is properly escaped.  The files will be  
> UTF-8
> encoded, so that the Unicode data that is currently in the database  
> will
> be properly represented.
>
> The same program can also emit some SQL commands that set the sequence
> numbers, grants, or whatever.
>
> SDSC has assured us that they can provide enough disk space at SDSC to
> do this.
>
> Files can be copied from SDSC to NESCent with any of several methods,
> including rsync.
>
> Once at NESCent, someone (who?) will be responsible for executing  
> these
> large SQL batch files to import the data into the Pg database.  If  
> done
> properly, the Unicode data will be transferred faithfully.
>
> If this sounds like a bad idea, or if there are unanswered questions,
> now is the time to speak up.
>
>
>
> ------------------------------------------------------------------------------
> Register Now for Creativity and Technology (CaT), June 3rd, NYC. CaT
> is a gathering of tech-side developers & brand creativity  
> professionals. Meet
> the minds behind Google Creative Lab, Visual Complexity, Processing, &
> iPhoneDevCamp as they present alongside digital heavyweights like  
> Barbarian
> Group, R/GA, & Big Spaceship. http://p.sf.net/sfu/creativitycat-com
> _______________________________________________
> Treebase-devel mailing list
> Tre...@li...
> https://lists.sourceforge.net/lists/listinfo/treebase-devel

-- 
===========================================================
: Hilmar Lapp  -:-  Durham, NC  -:- hlapp at duke dot edu :
===========================================================