469,643 Members | 1,220 Online
Bytes | Developer Community
New Post

Home Posts Topics Members FAQ

Post your question to a community of 469,643 developers. It's quick & easy.

urgent DB export issue

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
Jul 23 '05 #1
1 1200
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

Jul 23 '05 #2

This discussion thread is closed

Replies have been disabled for this discussion.

Similar topics

205 posts views Thread by Jeremy Siek | last post: by
6 posts views Thread by Oliver Stratmann | last post: by
13 posts views Thread by Hemant Sipahimalani | last post: by
2 posts views Thread by mike_dba | last post: by
6 posts views Thread by jefftyzzer | last post: by
By using this site, you agree to our Privacy Policy and Terms of Use.