Update dataset and data sources to include new columns

Question

VS 2010 VB.Net

SQL Server 2008

I have an App I'm developing to be occasionally connected to an SQL server 2008 DB. Most of the development is complete, however a design change has required the addition of a Column in several of the Server tables. I can't seem to get these changes to reflect in the client Tables.

Does anyone have any suguestions as to how I can get the client tables to reflect design changes in the server tables?

Answer 1

If you have done that in the database (not this forum) then click on the XSD and choose configure and let it run again.

 

---

Success
Cor

Answer 2

If you have done that in the database (not this forum) then click on the XSD and choose configure and let it run again.

 

---

Success
Cor

The problem is the Local Database Cache (SDF file) is not reflecting the changes in the server tables. The XSD file looks to the SDF.

Answer 3

OK I found an answer. I'm not sure this is the best method, or that there is not another way, but this works.

1)     Make sure the server DB is updated with any changes from the client. (No new columns yet)

2)     I used windows explorer to navigate to the client DB (SDF file)

3)     Delete Client DB (SDF file)

4)    Add new columns to Server DB.

5)    Sync DB's. I used a sync routine, but I'm sure you could use the Sync designer in the solution explorer.

6)    Go to the Data Sources pane, and right click the DB. Select Configure DB with wizard.

Your new columns will be available to select.