Cross machine file transfers

[Snyder, Tim]

Michael,
	We did exactly that going from HP3000/Image-SQL to NT/MS-SQLServer
in 1998 (see Paper 504 at the Enterprise 2000 Conference).  We used portable
subfile formats.  The target database was similar but not identical to the
original database.  For the two largest tables (one was 1.6M and the other
150k), we used BCP to load the data.  We were running Powerhouse 7.09 (QUIZ)
on the HP and Axiant/Powerhouse (QTP) on NT (2.02/8.01C).  We did all the
selection/transforming/reformatting with QUIZ.  We also disabled the normal
transaction logging on the target database to speed up the process.  We
matched record counts and hash totals 100% and executed the data migration
in a single day (no production down time).  We did all the error checking up
front to avoid duplicate keys, etc.  It worked well.
	Tim Snyder
	508-650-8420

> ----------
> From: 	Michael Lee[SMTP:Michael.Lee@mclsystemsinc.com]
> Reply To: 	Michael.Lee@mclsystemsinc.com
> Sent: 	Monday, July 31, 2000 3:42 PM
> To: 	Powerhouse User List
> Subject: 	Cross machine file transfers
> 
> One of my clients has similiar databases on two different machines: an
> HP MPE & a Unix. They would like to know how easy it so transfer data
> between one database and the other. Unfortunately neither are the
> database types the same nor do all the files map out exactly the same.
> 
> It would be nice if we could create Powerhouse subfiles on one machine,
> move them to the other machine and reload the data-but this doesn't seem
> feasible.
> 
> Has anyone else had the same issues and, if so, how have you resolved
> them?
> 
> Thanks for any ideas.
> 
> Michael Lee
> MCL Systems Inc.
> 
> = = = = = = = = = = = = = = = = = = = = = = = = = = = = = = = = = = = = =
> =
> Subscribe: "subscribe powerh-l" in message body to
> majordomo@lists.swau.edu
> Unsubscribe: "unsubscribe powerh-l" in message to majordomo@lists.swau.edu
> This list is closed, thus to post to the list, you must be a subscriber.
> 
= = = = = = = = = = = = = = = = = = = = = = = = = = = = = = = = = = = = = =
Subscribe: "subscribe powerh-l" in message body to majordomo@lists.swau.edu
Unsubscribe: "unsubscribe powerh-l" in message to majordomo@lists.swau.edu
This list is closed, thus to post to the list, you must be a subscriber.