Export To DBMS

[mjkelly]

I'm using 'export to DBMS' to export data directly into a SQL Server table. Is there a way to skip the deleted records (without doing a pack since I don't want them actually deleted from my .dbf file) when I use the 'export to DBMS' feature?

Thanks.

[Admin]

Hi Mary Jane!
Yes, of course. There is the 'Skip deleted records' option in the Generate SQL Scripts window.

[mjkelly]

But I'd like to be able to skip the deleted records using the 'export to DBMS' feature because of the imbedded appostrophes that I have in some of my string fields. But it doesn't look like I can skip the deleted records when using the 'export to DBMS', right, without doing a pack of the file?

[Admin]

Oh, sorry
You are right, there are no such option in Export to DBMS dialog for now. But it looks like we'll add it in one of future versions of DBF Commander Pro.

Did you try 2 of other ways I've described by e-mail? Were they (or one of them) helpful for you?

[Support]

Hi!
By the way, there is one more simple way.
Execute the SELECT query at first, e.g.:

Code: Select all

SELECT * FROM table1

then export the SQL query result data to server. The point is that deleted records do not participate in SELECT clause.
This allows you to load your data without source file change.

[mjkelly]

Great suggestion....I will try that. Thanks.