address line encrypted how to encrypt

mawimawi Posts: 4 New member
address line encrypted by filling up realistic data, how to encrypt it
Tagged:

Answers

  • RichardLRichardL Posts: 418 Gold 4
    Hi @mawi

    Thanks for your post. 

    Could you please provide as much detail as possible so that we can better understand your query? 

    Kind regards
    Customer Support
    Redgate Software
  • mawimawi Posts: 4 New member
    hello richardL thank you for the reaction
    assumption
    I have a rich experience of sql data bases
    i created a database with only one table to test redgate essentials.
    id as integer,firstname as varchar,lastname as var char, street as varchar
    i run redgate 4 as prescibed
    the data for firstname lastname gives good results however street gaves encrypted data
    the regular expression in the streetline shows (A-Z0-9)*
    if i put a curious reg expression  which i found somewher like ([1-9][0-9][0-9]?) N0rth [ east .... a very long not understable expression
    After filling in and restart the pc the data were correct 
    Curious
    I am curious what an expert may say to that
    greetings from switzerland
  • mawimawi Posts: 4 New member
    remember now where i get this curious reg expression. It was in redgate cusomers database. the reg expression matches the possible adress description. this is a unprofessional solution. you can do better greetings mawi
  • RichardLRichardL Posts: 418 Gold 4

    Hi @mawi


    Thanks again for your information. 

     

    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
  • mawimawi Posts: 4 New member
    Hi RichardL
    The problem is that a regular expression in the data line is needed. How the regular expression should be depend on the data you wish to import. An impossible solution. The result is that i bought sql essentials and sql prompt together som 600 Euro and i can not use it. 
    I certain will not recommended redgate, sorry
    greetings
    mawi
  • RichardLRichardL Posts: 418 Gold 4
    Hi @mawi

    Thanks again for your post. 

    I can see that you are entitled to support on your products from our techn ical engineers. 
    Please send us a ticket so that we can help you with your issue via this channel. 

    Kind regards

    Richard Lynch. 
    Customer Support
    Redgate Software
Sign In or Register to comment.