[Info-Ingres] DataMigration

[Paul White]

Hi Puneet,
 
I'm not sure what you should do on ingress but on ingres,  the command
you need is copydb.
 
If the servers are the same OS / architecture you can use a binary copy
- something like this.
 
copydb olddatabase mytable 
sql olddatabase < copy.out
...
copy the data and scripts to new machine
...
sql newdatabase < copy.in
 
 
if the machines are of different architecture you can use the same
command and let ingres net do the work.
 
I copy between windows and unix like this:
 
Log into windows server  (for Ingres 2.6 or higher)
copydb @oldserver,wintcp,II[ingres,ingrespasswd] :: olddatabase
mydatabase mytable 
sql @oldserver,wintcp,II[ingres,ingrespasswd] :: olddatabase < copy.out
sql newdatabase < copy.in
 
If you have to transport the data between different machine types and
they are not on a lan you should copydb -c. But beware of floating point
numbers. You will need to specify precision.   If you have large amounts
of data you also need to consider your transaction log size.
 
There is some good documentation on bulk copying. Check your manuals.
 
 
Paul



________________________________

	From: Puneet Bagoria [mailto:puneet138 at gmail.com] 
	Sent: Thursday, 15 March 2007 8:15 PM
	To: Paul White
	Subject: Re: [Info-Ingres] DataMigration
	
	
	Sorry Paul, I didnt get what you want to mean.
	
	
	On 3/15/07, Paul White <pwhite at peerlessit.com.au> wrote: 

		Puneet,
		there is only one s in ingres.
		 
		 


________________________________

			From:
info-ingres-bounces at kettleriverconsulting.com
[mailto:info-ingres-bounces at kettleriverconsulting.com] On Behalf Of
Puneet Bagoria 
			Sent: Thursday, 15 March 2007 7:42 PM
			To: Info-Ingres at kettleriverconsulting.com 
			Subject: [Info-Ingres] DataMigration
			
			 
			Hi,
			
			In Ingress how data is migrated to another
version of the database?I want to migrate few tables from one version of
Ingress to another , both the source and destination table has got same
structure. 
			Like for Oracle database Toad provides feature
to generated insert scripts to a flat text file and these scripts can be
used to load the data using toad . 
			
			Do we have such facility in Ingres also, if not
then how migration can be done? 
			
			Thanks,
			Puneet


-------------- next part --------------
An HTML attachment was scrubbed...
URL: http://www.kettleriverconsulting.com/mailman/private/info-ingres/attachments/20070315/a90dc6bd/attachment.html