dbForge doesn't allow to go back after an error to fix the mapping during import data. I spent a few minutes editing the mappings and when I was ready to import data from a text file to a new table, I got an error right away. Seems like a date column was not in a valid date format for SQL Server. The Back button was disabled so I couldn't fix the column mapping and I had to start from scratch. Annoying!
Also, SSMS was smart enough to get the column names from the first row. dbForge didn't. It just named my columns: column1, column2, column3.. etc.
dbForge doesn't allow to go back after an error to fix the mapping during import data
-
alexa
Re: dbForge doesn't allow to go back after an error to fix the mapping during import data
You could save/load the settings in the *.dit data import template.dbForge doesn't allow to go back after an error to fix the mapping during import data. I spent a few minutes editing the mappings and when I was ready to import data from a text file to a new table, I got an error right away. Seems like a date column was not in a valid date format for SQL Server. The Back button was disabled so I couldn't fix the column mapping and I had to start from scratch. Annoying!
You can select select which row to use in the 'Header -> position' field on the 'Options' page of the data import wizard.Also, SSMS was smart enough to get the column names from the first row. dbForge didn't. It just named my columns: column1, column2, column3.. etc.