Welcome To The Home Of The Visual FoxPro Experts  
home. signup. forum. archives. search. google. articles. downloads. faq. members. weblogs. sponsors. rss.
 From: Ken Murphy
  Where is Ken Murphy?
 Springhill
 Canada
 Ken Murphy
 To: Leslie Botchway
  Where is Leslie Botchway?
 
 Ghana
 Leslie Botchway
 Tags
Subject: RE: Convert SQL-script from VFP to SQL Serve
Thread ID: 161833 Message ID: 161943 # Views: 23 # Ratings: 0
Version: Not Applicable Category: Databases, Tables and SQL Server
Date: Wednesday, February 27, 2008 8:59:10 PM         
   


> >
> > Suhas,
> >
> > I haven't tested the latest version of the upsizing wizard - I gave up on the wizards very early on. I am with Borislav on this though. When you move to a SQL backend, you are doing a fairly major revision. That is the perfect time to take a look at the way you want it to work on SQL and make the desired changes. When I moved my database up to SQL, I did the entire design again on paper. I made design decisions that were different than the ones that I would have made in a VFP backend. I then wrote a quick and dirty little "Mickey Mouse" program that imported the data from VFP to SQL. During testing, I actually ran that little Mickey Mouse program nightly. My users would then start out each moring with the same data on both the VFP version and the SQL version. It allowed them to run "real life" tests.
> >
> > Ken
> > You shall know the truth - and the truth shall set you free. (John 8:33)
>
>
> Check this site
> http://ae.inc.ru/dbf2mysql.php
>
> Leslie Botchway
> Ghana

Something new for me to look at :) My rating to you.

Have you used this? Does it do as advertised?

Ken
You shall know the truth - and the truth shall set you free. (John 8:33)



COMPLETE THREAD
Convert SQL-script from VFP to SQL Serve Posted by None None @ 2/27/2008 3:35:56 PM
RE: Convert SQL-script from VFP to SQL Serve Posted by tushar @ 2/27/2008 3:45:21 PM
RE: Convert SQL-script from VFP to SQL Serve Posted by Cetin Basoz @ 2/27/2008 4:01:39 PM
RE: Convert SQL-script from VFP to SQL Serve Posted by None None @ 2/27/2008 4:07:33 PM
RE: Convert SQL-script from VFP to SQL Serve Posted by Cetin Basoz @ 2/27/2008 4:18:18 PM
RE: Convert SQL-script from VFP to SQL Serve Posted by Borislav Borissov @ 2/27/2008 6:41:11 PM
RE: Convert SQL-script from VFP to SQL Serve Posted by Ken Murphy @ 2/27/2008 7:04:33 PM
RE: Convert SQL-script from VFP to SQL Serve Posted by suhas hegde @ 2/27/2008 7:07:20 PM
RE: Convert SQL-script from VFP to SQL Serve Posted by Borislav Borissov @ 2/27/2008 7:11:52 PM
RE: Convert SQL-script from VFP to SQL Serve Posted by suhas hegde @ 2/27/2008 7:18:10 PM
RE: Convert SQL-script from VFP to SQL Serve Posted by Borislav Borissov @ 2/27/2008 7:32:08 PM
RE: Convert SQL-script from VFP to SQL Serve Posted by suhas hegde @ 2/27/2008 7:34:46 PM
RE: Convert SQL-script from VFP to SQL Serve Posted by Borislav Borissov @ 2/27/2008 7:44:06 PM
RE: Convert SQL-script from VFP to SQL Serve Posted by suhas hegde @ 2/27/2008 7:49:00 PM
RE: Convert SQL-script from VFP to SQL Serve Posted by Borislav Borissov @ 2/27/2008 7:56:47 PM
RE: Convert SQL-script from VFP to SQL Serve Posted by Ken Murphy @ 2/27/2008 7:20:38 PM
RE: Convert SQL-script from VFP to SQL Serve Posted by suhas hegde @ 2/27/2008 7:32:13 PM
RE: Convert SQL-script from VFP to SQL Serve Posted by Ken Murphy @ 2/27/2008 8:06:04 PM
RE: Convert SQL-script from VFP to SQL Serve Posted by suhas hegde @ 2/27/2008 8:13:44 PM
RE: Convert SQL-script from VFP to SQL Serve Posted by Ken Murphy @ 2/27/2008 8:22:09 PM
RE: Convert SQL-script from VFP to SQL Serve Posted by Leslie Botchway @ 2/27/2008 8:55:22 PM
RE: Convert SQL-script from VFP to SQL Serve Posted by Ken Murphy @ 2/27/2008 8:59:10 PM
RE: Convert SQL-script from VFP to SQL Serve Posted by Anders Altberg @ 2/29/2008 3:30:34 AM
RE: Convert SQL-script from VFP to SQL Serve Posted by William Sanders @ 2/27/2008 6:02:54 PM