Import Feature

russ0519russ0519 New memberPosts: 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?
Tagged:

Answers

  • RichardLRichardL Gold 4 Posts: 418 Gold 4
    Hi @russ0519

    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 [email protected], and they'll be able to help.
    Customer Support
    Redgate Software
Sign In or Register to comment.