Re: Data migration Verification

2007-06-05 Thread Joerg Bruehe
Hi ! paulizaz wrote: What do you mean by "same output" ? I have too much data to go through and check if all the data is the same. This is my problem. Sampling would speed this up, but I need something more accurate. All data is important. In Unix / Linux, you would generate similar plain-te

Re: Data migration Verification

2007-06-04 Thread Baron Schwartz
On 6/4/07 12:31 PM, "paulizaz" <[EMAIL PROTECTED]> wrote: I have too much data to go through and check if all the data is the same. This is my problem. Sampling would speed this up, but I need something more accurate. All data is important. Then I think you will also have to write a reverse mi

Re: Data migration Verification

2007-06-04 Thread Olaf Stein
I don't mean the whole thing. Pick some output that your applications usually produce and see if you can get the same results for both databases. I am not saying that this is the only and best way, just in addition to the mentioned sample approach. If you want to know for sure you will have to wr

Re: Data migration Verification

2007-06-04 Thread Wm Mussatto
On Mon, June 4, 2007 9:31, paulizaz said: > > What do you mean by "same output" ? Can you write a program to access both databases and have it check to see if the data matches. A lot depends on how the structure changed. If the new database rows have a one to one correspondence to the original da

Re: Data migration Verification

2007-06-04 Thread paulizaz
or the migration) >> >> Free Software, scripts, utilities, packages, industry approaches?? >> >> Sorry Im no Tech wizzard, Any ideas appreciated. > > > -- > MySQL General Mailing List > For list archives: http://lists.mysql.com/mysql > T

Re: Data migration Verification

2007-06-01 Thread Olaf Stein
Besides the sample approach, output data (a set you would output on a live system anyway) from both db setups and see if you can get the same output from both Olaf On 6/1/07 10:35 AM, "paulizaz" <[EMAIL PROTECTED]> wrote: > > Hi all, > > I have somebody creating a C# class to migrate data fr

Data migration Verification

2007-06-01 Thread paulizaz
?? Sorry Im no Tech wizzard, Any ideas appreciated. -- View this message in context: http://www.nabble.com/Data-migration-Verification-tf3852626.html#a10913962 Sent from the MySQL - General mailing list archive at Nabble.com. -- MySQL General Mailing List For list archives: http

data migration question

2004-09-23 Thread sean c peters
I have a table that i am modifying the schema of, and am having a particular problem with my data migration program. The old format has a column defined as: Range char(3) not null default '', which is either'' or contains a number (1 or 2 digits), and is sometimes followed

Data Migration between 2 different schemas

2003-11-06 Thread Ravi Kumar
Hi !! I am new to My SQL. I have got a requirement where data existing in one schema has to be migrated to another. Both schemas look alike except some minor changes in the table definitions here and there. Does MySQL provide some kind of tools by default for these sort of things or we need to go

RE: data migration

2002-09-05 Thread Sekhar.Thota
Hi, I am using sqlporter utility for the data migration. You can download the trail version and can use. Regards, Sekhar -Original Message- From: Khanh Pham-Phu [mailto:[EMAIL PROTECTED]] Sent: Thursday, September 05, 2002 9:32 AM To: [EMAIL PROTECTED] Cc: [EMAIL PROTECTED] Subject: Re

Re: data migration

2002-09-05 Thread Khanh Pham-Phu
Hi, You may look up this URL for data migration: http://www.mysql.com/portal/software/html/software_comments-124.html Good Luck, /Khanh > HI ALL, > > Does anyone know of a simple way of migrating JUST data from a sybase > ASE server to mysql ? > > Please Help :) &

data migration

2002-09-04 Thread Tonino
HI ALL, Does anyone know of a simple way of migrating JUST data from a sybase ASE server to mysql ? Please Help :) Thanks Tonino - Before posting, please check: http://www.mysql.com/manual.php (the manual) h

Re: data migration between different computers with mysql

2002-07-08 Thread Bhavin Vyas
computers, your approach should certainly work. Regards, Bhavin. - Original Message - From: "Prashant Pai" <[EMAIL PROTECTED]> To: <[EMAIL PROTECTED]> Sent: Monday, July 08, 2002 8:59 AM Subject: data migration between different computers with mysql > Hi, > > I a

data migration between different computers with mysql

2002-07-08 Thread Prashant Pai
Hi, I am new to the database world, so I wanted to get some facts straight. I have built an application which runs with MySQL. I want to distribute the application along with the data. The target computers would also have MySQL. I have observed that I can zip up the data directory under mySQL and