Data Migration App - Anyone interested

[SteveDingle]

Heya All,

I have created a VFP 9 app that migrates data from a vfp database to a SQL 2K database and subsequently keeps the destination database up to date by querying for changes in a log table and updating the destination database. The only requirement is that the table field names are the same and the data types are "compatible".

My plan is to eventually extend it to work with other backends and also a VFP to VFP migration and also all for a field mapping mechanism but... baby steps

Anyway, it's still in beta testing with the client I created it for but thought if anyone else would be interested in it .. well I would get some free feedback and testing ;-)

If its something you might be interested in you can down load the "basic" help file here...

http://www.dsbusinesssolutions.co.uk/DataMigrator.chm

... and then send me a note and I'll send you the app. If there is enough interest I'll put the app on the site and do this more formally.

Toodles,
Steve Dingle

http://www.dsbusinesssolutions.co.uk

D&S Business Solutions Ltd

 

[baltman]

Check out VFPx on codeplex.com

http://www.codeplex.com/Wiki/View.aspx?ProjectName=VFPX

I am interested in the synch logic as I'm planning on creating a DBF that is a real-time snapshot/view of a subset fields/records of a MS SQL database for FAST reporting.

Brian

 

[SteveDingle]

Hello Brian

>>VFPx
I had taken a look there awhile back but couldn't find much, must have been right at the change from sednaX. Defintely something good for community but don't think my app would appropriate for there tho

My app won't work at all for what you're looking for in its current state (but would in future versions if enough interest). I'm going from VFP to SQL and also assuming that tables structures match. Sounds like you're pulling from SQL and creating a flat file of various tables and fields (which a field mapping would be required)

However if there is anything you think I might have had to deal that I could help you with feel free to ask and I'll do my best to help

Toodles,
Steve Dingle

http://www.dsbusinesssolutions.co.uk

D&S Business Solutions Ltd

 

[SteveDingle]

Heya Mike,

Yes though my client is also using it to keep the data up-to-date. Basically we're re-writing there system in VFP/C# hybrid and moving the data to SQL Server, but they have existing systems that could benefit from access to the in SQL Server. Plus since the upgrade will be implmented over many months we needed to keep it in VFP but have a current copy in SQL Server for testing.

This functionality does assume there is a change log table in the VFP database which identifies the table/pk/action taken on a give record and also a field to flag whether it has been processed by the data migrator.

My long term plan for the app is to help with upsizing AND distributed database and the like but again thats "long term". Still pretty basic at this stage of the game but thought with input from others could make it something useful for the community at large

tc,
steve

Toodles,
Steve Dingle

http://www.dsbusinesssolutions.co.uk

D&S Business Solutions Ltd