Import Feature
russ0519
Posts: 3 New member
I love using the SQL Data Generator to import TSV files into sql server. There are 2 issues with this.
1. I need to create the table first. I usually use the SQL Server Import Wizard for this. It creates the table, but fails to import, so I turn to SQL Data Generator.
2. Sometimes (especially when the columns have symbols in them and don't match between sql server and the tsv file, it will try to autogenerate that column. I get it, because that is what this feature is really for.
My question is - am I just using the wrong tool. Is there another red-gate tool that does tsv imports reliably?
1. I need to create the table first. I usually use the SQL Server Import Wizard for this. It creates the table, but fails to import, so I turn to SQL Data Generator.
2. Sometimes (especially when the columns have symbols in them and don't match between sql server and the tsv file, it will try to autogenerate that column. I get it, because that is what this feature is really for.
My question is - am I just using the wrong tool. Is there another red-gate tool that does tsv imports reliably?
Tagged:
Answers
This looks like a question that one of Support engineers will need to investigate for you.
If you've a got support contract, please send us a ticket. Provide as much information as you can - screenshots of any errors, log files etc – so we can help you as fast as possible.
If you're not covered by a Support contract at the moment, email our Sales team at sales@red-gate.com, and they'll be able to help.
Redgate Software