Viewing 15 posts - 61 through 75 (of 1,626 total)
I think of way that may do it. I can add a column named row_number in the query for each table, and join with the row_number to update other columns...
February 16, 2022 at 7:17 pm
Basically I have two tables, one is AddMasterAddress table with 10000 records, the other is a new fake dataset let's call it FakeAddress table which has no identity column. So...
February 16, 2022 at 6:48 pm
yes, the performance are better if I test small batches of updating.
February 15, 2022 at 7:14 pm
sorry, the extension sql is not allowed, changed to .txt, attached
February 14, 2022 at 10:32 pm
Also the trigger is to add logs to another table. This is usually used when user change address from user interface web site, so it is usually one record one...
February 14, 2022 at 9:51 pm
Yes, I did check the log space, I see there is plenty space while it is running.
This is a non-production environment for me to scramble data.
So I was able to...
February 14, 2022 at 9:48 pm
That works perfectly, thanks much!
February 13, 2022 at 4:01 am
Thank you. It looks like the Modern_Spanish_CI_AS stored spanish mainly. What we want is still a database mostly stored English, but just for sometimes if users like to display their...
February 9, 2022 at 12:56 am
A second thought I do have license of Redgate of data generator as in the toolbelt bundle. Never used this tool, but maybe it can be used to replace columns'...
January 26, 2022 at 11:39 pm
Thanks all.
For answering this question: But do you really need the whole production database in none prod? Could you get away with using a blank schema and using a data...
January 26, 2022 at 11:22 pm
Thank you both.
The product is good, but it is expensive. Not sure if we can get approval to have budget for that.
Any other recommendations?
Thanks
January 26, 2022 at 6:48 pm
Yes, I totally understand the user cannot run the select query, because he doesnot have permissions on Production schema.
It is the stored procedure permissions that confused me. But Andy's answer:...
January 19, 2022 at 9:19 pm
Thanks for your recommendations. What I can say is the .exe is calling our local web application that calls vendor's web service end points. Vendor side web service is the...
August 18, 2021 at 3:28 pm
Yes, the step is execute process task that has a executable C:\_SSISFILES\Miscellaneous\eLinkUtility\Transportation.ETL.VersaTransToStaging.exe
The executable call the web service that has endpoints.
August 18, 2021 at 1:19 am
Viewing 15 posts - 61 through 75 (of 1,626 total)