urgent DB export issue

[thaar]

hi everybody,
iam soory maybe my question is easy, i heard about a product that can
solve such problems, but i forgetted.

the problem:
we have several foxpro6 systems, each one with seperated DB.
Now we build a new complete DB for all systems using MS_SQL Server
2000, we need to transfer/export old Data to new DB taking all
situations such as the data for one system (SALARY system) that
working on employee table is not comaptible with other data from other
system (emplyees system) that worked on the same table employee. How
we can solve such issue using MS products or other products if
available.

thanks inadvance for any advice.

best regards

eng thaar

CNS

[Simon Hayes]

Two general options are to export data from Foxpro to flat files, then
use bcp.exe, BULK INSERT or DTS to load the files into MSSQL; or, use
DTS to move the data directly from Foxpro into MSSQL. In both cases, it
would probably be useful to load the data into a staging table or
tables first, then you can use TSQL to clean it up, find and remove
duplicates etc. before you finally insert it into the target tables.

As for how to make the data from each source database "compatible", it
sounds as if you're saying that each source database has implemented
the Employees table differently? If so, there's no general solution to
that question - you'll have to design an Employees table for your MSSQL
database, then work out how to load the data from each source and merge
it - the details would depend on your current design, your new data
model, your company's business logic etc.

Simon