Problem with .xsd datasets

  • Thread starter Thread starter GaryDean
  • Start date Start date
G

GaryDean

I have a number of .xsd datasets in my asp.net 2.0 app that access my Paris
database. I cloned the database and named the new one Milan. I see the
xsds all have Paris hard coded in them. do I have to recreate all of the
xsds?
 
Hi Gary,

For a single DataSet, you can select "Configure" menu on the Dataset
designer to open the "TableAdapter Configuration Wizard" and select
"Previous" steps to reconfigure the database connection string.

I understand that you have lots of DataSet, which is tedious to
re-configure each DataSet. However, there're no user interface could let
you easily change all DataSet's database name. Given that the .xsd file is
also a text file, I think you can use find/replace to change the database
name manually:

1) Backup files if necessary
2) Close all documents in VS2005
3) Select all your .xsd files in Solution Explorer and right-click, select
"View Code"
4) Use menu "Edit/Find and Replace/Replace in Files", choose "All open
documents" in "Look in" field; and replace accordingly: based on my test,
you should only need to replace

DbObjectName="Paris.

with

DbObjectName="Milan.



Hope this helps.

Regards,
Walter Wang ([email protected], remove 'online.')
Microsoft Online Community Support

==================================================
When responding to posts, please "Reply to Group" via your newsreader so
that others may learn and benefit from your issue.
==================================================

This posting is provided "AS IS" with no warranties, and confers no rights.
 
Hi Gary,

Please feel free to let me know if there's anything else I can help. Thanks.


Regards,
Walter Wang ([email protected], remove 'online.')
Microsoft Online Community Support

==================================================
When responding to posts, please "Reply to Group" via your newsreader so
that others may learn and benefit from your issue.
==================================================

This posting is provided "AS IS" with no warranties, and confers no rights.
 
Back
Top