SQL 2008 & Occasionally Connected Client Support in Visual Studio SP1
- Posted: Aug 08, 2008 at 5:07 PM
- 46,950 Views
- 8 Comments
Download
How do I download the videos?
- To download, right click the file type you would like and pick “Save target as…” or “Save link as…”
Why should I download videos from Channel9?
- It's an easy way to save the videos you like locally.
- You can save the videos in order to watch them offline.
- If all you want is to hear the audio, you can download the MP3!
Which version should I choose?
- If you want to view the video on your PC, Xbox or Media Center, download the High Quality WMV file (this is the highest quality version we have available).
- If you'd like a lower bitrate version, to reduce the download time or cost, then choose the Medium Quality WMV file.
- If you have a Zune, WP7, iPhone, iPad, or iPod device, choose the low or medium MP4 file.
- If you just want to hear the audio of the video, choose the MP3 file.
Right click “Save as…”
- Mid Quality WMV (Lo-band, Mobile)
In this interview, Milind Lele, a PM on the Visual Studio Pro Tools team shows us the improvements made to the tooling in Visual Studio SP1 for occasionally connected clients as well as the new data type support for SQL Server 2008. Using SQL 2008 built-in
change tracking, you don't need to make modifications to your table schemas like you have to do with SQL 2005. Additionally he shows off a "smarter" DataSet designer where you can have tables coming from server and client data stores all contained within one
model.
Enjoy,
-Beth Massi, VS Community
Enjoy,
-Beth Massi, VS Community
Comments Closed
Comments have been closed since this content was published more than 30 days ago, but if you'd like to continue the conversation,
please create a new thread in our Forums,
or
Contact Us and let us know.
Follow the Discussion
The moment the tables are synchronized (13:21) the order data changes! The customer jumps from "Vins et alcools Chevalier" to "Alfreds Futterkiste", employee from "Buchanari" to "Davolio.", and shipper from "Federal Shipping" to "Speedy Express"... But I guess we didn't change that after our sync... How come?
Sincerely, Greg.
Keep up the great work!
the small pip of the interview during on screen demos are awsome though
Its possible that when the dataset got repopulated, the current record was reset to the first record.
Indeed.
This is because after the sync I did a fill for the datasets. This clears and refills that dataset.
A better approach is to use merge.
Me.NorthwindDataSet.Shippers.Merge(Me.ShippersTableAdapter.GetData())
Unfortunately, no. The Sync Services runtime does not support non-SQL Server databases.
Remove this comment
Remove this thread
close