Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
| Author |
Topic |
|
AskSQLTeam
Ask SQLTeam Question
0 Posts |
 Posted - 2005-05-19 : 07:32:19
|
| Anoop writes "On porting the data from vFoxpro to sql server i noticed a data loss of 63 data out of 1.6 lakh. How to compare the tables of Vfoxpro and sql? and locate the loss data?" |
|
|
AjarnMark
SQL Slashing Gunting Master
3246 Posts |
Posted - 2005-05-19 : 13:31:08
|
| A loss of "63 data"? Does that mean 63 rows?You could setup a linked server to the FoxPro database from SQL Server, then do a LEFT JOIN on the Primary Key of the table and show only data where the Right side is NULL. Something like:SELECT FP.*FROM myFoxProTable FPLEFT JOIN mySQLTable S on FP.PrimaryKeyField = S.PrimarKeyFieldWHERE S.PrimaryKeyField IS NULLNote that you'll need to use more 4-part naming in order to reference tables in the linked server.---------------------------EmeraldCityDomains.com |
 |
|
|
|
|
|
VisalFoxpro- SQL porting