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
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
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.
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
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.
mawi
Posts: 4 New member
Answers
Thanks for your post.
Could you please provide as much detail as possible so that we can better understand your query?
Kind regards
Redgate Software
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
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.
Redgate Software
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
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.
Redgate Software