Problem:
As part of an USER / CLIENT / REPOSITORY Clean up I am trying to re-align the user accounts to the right clients and the projects to the right clients.I have a number of projects that i want to change from "Internal" to a Newly created Client. I also have some clients that I want to delete the client record after having reassigned the users to the Newly create Client, but there are a couple of projects that use the Client Name and so I cannot delete the client record.I am not able to EDIT the Client name via the "Edit Project"...
Is there a SQL Script that would allow me to change the client?
Resolution:
Editing Client name will not change the project name
To change the client name
update tbl_pj_ClientInfo set ClientName='<Client name>' where ClientID = <Client ID>
and then change the client id from tbl_pj_projectsetup table
update tbl_pj_projectsetup set clientid = <Client ID> where Projectid = < Project ID>
Comments
0 comments
Please sign in to leave a comment.