Powershell Script to update SQL Database

Hello to anyone who comes across this.

I have two tables in the same database

I am looking to update Store_Manager_ID in table 1 that is currently blank with the result from securityPrincipal in Tablet 2 where the Email address's in both tables match all this needs to happen in powershell

Table 1
Store_Manager_Email - (Contains Email Address)
Store_Manager_ID - (Blank)

Table 2
user.mail - (Contains Email Address)
securityPrincipal (Contains User ID)
adznonAsked:
Who is Participating?
I wear a lot of hats...

"The solutions and answers provided on Experts Exchange have been extremely helpful to me over the last few years. I wear a lot of hats - Developer, Database Administrator, Help Desk, etc., so I know a lot of things but not a lot about one thing. Experts Exchange gives me answers from people who do know a lot about one thing, in a easy to use platform." -Todd S.

 
Jose Gabriel Ortega CEE Solution Guide - CEO Faru Bonon ITCommented:
I think that you just need to do a foreign key from table 1 to table 2 in the corresponding fields.

If you want to do just the inserts here's a PS:
https://technet.microsoft.com/en-us/library/hh289310.aspx

if you want to do the modification of the table (the way it should do)
Here's an example

http://www.itprotoday.com/microsoft-sql-server/modify-columns-and-stored-procedures-powershell
0

Experts Exchange Solution brought to you by ConnectWise

Your issues matter to us.

Facing a tech roadblock? Get the help and guidance you need from experienced professionals who care. Ask your question anytime, anywhere, with no hassle.

Start your 7-day free trial
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

All Courses

From novice to tech pro — start learning today.