Last post Jul 21, 2015 05:57 PM by codequest
Jul 21, 2015 04:34 PM|codequest|LINK
I'm updating an app that uses several typed data sets, each of which points to one of three sql data bases: DB1, DB2, DB3.
I'm going to merge the three DBs into DB_ALL, and create a new connection string to it.
When that's done, I'd like some way of editing the datasets to use the new connection string, so I don't have to recreate them (agh!)
I'm thinking I might be able to do a find/replace all on the .XSD file for the datasets, to replace the old connection string name with the new one.
Will this work, or are there other issues that I need to consider?
Jul 21, 2015 04:46 PM|DeadTroll|LINK
Yes, doing a Search and Replace should work just fine. Just remember to keep the files open incase it messes things up you can go back and undo the replace.
Jul 21, 2015 05:57 PM|codequest|LINK
Thanks for the answer. I also realized I could leave the connection string names and edit the connection string content to point to the one database, Good to have options!