Menu

Do a duplicates check during the CSV import

0 votes

I have 25,000 lines of data to import and I would like the dbFront CSV import to automatically manage the duplicate checks.

in How To by (7.0k points)
recategorized by

1 Answer

0 votes
 
Best answer

There are three options when importing data:

  1. Use the dbFront Quick Import Wizard,
  2. Create an Import Batch Process in dbFront for managed imports,
  3. Import directly with your database-specific tools.

Depending upon the data complexity and your dbFront configuration, a CSV or Excel file with 25,000 records should import successfully using the Quick Import.

If the Quick Import tests out successfully then the recommendation is to use the Import Batch Process. This involves: 1) importing the data into a staging table using Quick Import, 2) and then processing and validating the data using a stored procedure.

Otherwise, I would suggest using the tools provided by your SQL server to import the data directly. That would be most appropriate if you have a very large amount of data that needs to be imported by administrators.

For SQL Server: https://dbfront.com/qa/202/how-do-i-import-csv-data-into-sql-server-via-dbfront

by (64.3k points)
selected by
Welcome to the dbFront Q&A site, where you can ask questions and receive answers from other members of the community.
 | Minimalist Answer Theme by Digitizor Media
 |
Powered by Question2Answer
...