address line encrypted how to encrypt

mawi

address line encrypted by filling up realistic data, how to encrypt it

RichardL

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

mawi

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

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

RichardL

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.

mawi

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

RichardL

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.