address line encrypted how to encrypt

• 
  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

  RichardL March 16, 2018 14:14

  - 0 +
• 
  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

  mawi March 16, 2018 18:40

  - 0 +
• 
  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

  mawi March 17, 2018 18:34

  - 0 +
• 

  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 sales@red-gate.com, and they'll be able to help.

  RichardL March 19, 2018 11:18

  - 0 +
• 
  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

  mawi March 19, 2018 16:06

  - 0 +
• 
  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. 

  RichardL March 22, 2018 12:48

  - 0 +

Add comment

Please sign in to leave a comment.