Video: How Do I: Upgrade My Mobile Device Projects from Visual Studio 2005 to Visual Studio 2008?

Presenter:Jim Wilson

Learn how to upgrade the many different versions of .NET Compact Framework and SQL Server Compact projects from Visual Studio 2005 to Visual Studio 2008. Jim Wilson shows you how.


The following text is a software generated transcript of the video. Click on a minute link to jump to a location within the video


Minute 0
I m use to Wells and present them as a corporate in this video riff about how you can upgrade your copper framework and SQL Server combat condition projects in Visual Studio 2000 5030 2008 of this is that Visual Studio 2008 some pretty good build and upgrade capabilities so I worked to think Air Force automatically but there are a few cases that do require special attention so that he overloaded for situations out first one is a situation where you have a compact framework project is either cover 2 0 or 1 0 the second case is a common framework project that uses SQL Server 2005 product edition asserts that the situation is and I come up and work in an encrypted SQL Server 2005 competition database and finally a part of her project uses SQL Server CE 2 0 and so you started a petition is

Minute 1
Very simple prostitute can look at and see our Texas race of the most simple case and really have is out of project that chestnut CSN Prensa doesn t have any other relationships as as good a dramatic irony here and now this I remember although there s a few different scenarios that you might want to convert from status if you doesn t aid has very consistent rules for what it converts to basically any compact framework project that you upgrade from business into thousand five to 2008 will have covered for 2 0 no common misconception is that 2008 forces you to 3 5 that s not the case resume via an existing project uses cover from just 2 0 will be a maintain out of her to point out if you do have an older project uses cover for 1 0 proceeded as they does not support with one of

Minute 2
For that project is also upgraded to 2 0 rights of all funds will go to cover for two point prejudice to demonstrate a bit is really simple application you re the basically you run it at Exodus is the version information for an runtime and displays a text box in the wants us died not currently to middle two 2005 got here wanted to see in an emulator momentarily a basic and say that it launched up in a sea of version 2 0 0 recklessly as if to point out presenting it as respect Mrs encloses project and I will actually open up in middle two 2008 cells start to see if it doesn t meet and basically was not navigate to that project project we go to our justice if

Minute 3
Checked an open I die up and basically stated as this one to notice that an older version project doesn t find sort of the conversion Wizard is that through its is a tobacco copy of ruthlessly asked with you to the backup copy goes normally to our commute is the fault out whatever folder the original project is in existence underneath their is a next and what you just said source I happen the summary makes it very clear this data says that you know if this project is 1 0 or 2 0 cover project is on the upgraded to 2 0 man it s as simple as to what really is that in this case or upgrading is the project files are not affecting what a program exodus was that it is a finish into your room as you want and show the conversion what was done been saved by yesterday you so we close us now look at conversion log if you notice anything at

Minute 4
Or it was not really what I was working on a project for the solution file got upgraded to the new visions fugitives in the format similar to the Project filed in in the resource file formats upgraded in but not my source code resembles now when I run my project is still saying that CF 2 0 and its alleged and wanted in his e mail that is still missing a few point out for nothing changed it in the upgraded was the project files and self in laws like without it seems the information out about runtime which is clicking on project name and looking down here to framework version it s a photograph that whatever

Minute 5
And he will remain as see if to put a project but then you can right click on the project and does it have changed target platform and between things that Windows will find little sex upgrade project will take you to the next version of the CF are devising upgrade project is on the dildo and upgrade project now the 3 5 not reversible summit to realize and then we say yes so how does that outcries highlighted this is for her version 3 5 down here and if I run it will see in this case that we actually have our program running in side cover for 2 5 runtime razor is 3 5 is a remember there is that when you re 82 005 net CF project and importing it into two dozen eight resulting project is always in copper for her to point out my weather is really 2 0 or 1 0 resulting is always into pile

Minute 6
Five explicitly told to do so one to be aware of is that because smart 2003 did does not support great her for her person and his wife and 2003 0 is and can t be changed and how we see it as a so you have a smart phone 2003 project and poured it into Windows 2000 in that project will upgrade to cover for 2 0 card in the Windows mobile five smart for president as a special case with the smart for all of your Pocket PC projects in all of your other smart for project will simply part at the same place

Minute 7
In SQL Server compact edition 2005 brutally costly calls it was a recovered edition 2005 is actually SQL Server compact 3 03 100 open a project that we are to have his here in our projects I ve got another Friday here in net CF with SQL Server compact 2005 Mrs Goodman tonight I don t want Freeman remedy look it is discovered pretty normal project reference to look at it very simple election display forced to cover for her version and what it is to recover version as those addicted into the Northwind database and which is actually a suffer Compaq 2005 database would you data binding the Lunenburg Egret discussing up in her lamented internally the way I d get the version number for the SQL Server compact this would take one of the classes from the assembly

Minute 8
Aussie connection and basely final assembly is from prison to the assembly is a diverse number from the assembly so tell us what version of SQL Server compact would have loaded a rates of Gavin Visual Studio doesn t finally want to campesinos running its using a 50 0 rain SQL Server compact version 3 for no which is as SQL Server 2005 compact edition or something this project to bring up the Visual Studio 2000 and in closing your good start of Visual Studio 2000 and ran again and got here it is open project now navigate out to my net CF with the customer contact 2005 and over the solution members of the wizard does a good solicitous time as ago throw it on as a back up again as foreign

Minute 9
A felony that wrote it because as a cover for 2 0 project will remain a cover for two point project with a thing to be aware of is that any 33 03 1 SQL Server compact databases will now be upgraded 3 5 is the project itself will be upgraded to use the SQL Server conference to provide libraries and your database file is also upgraded to use the SQL Server conducts from 2 5 format rights of project and news follows of grit support note that my default Visual Studio 2008 does not support free SQL Server cover 3 5 database usage is if you have existing projects that use us in the server of mobile or six of her compact edition 2005 is a special thing to get you to handle that that will be the subject of a different video residency finish and go off and headed to his thing soon I say

Minute 10
And are so no longer done so close to the liquor the log files using other courses list was converted in a project files were converted else or resource losses before but notice that it s also converted the SDF files well I so the networks are referencing 3 5 libraries database has been converted to 3 5 format was that means now when I run this project we should see over the perverse information sought it was ecstasy version 3 5 adds the SQL Server compact edition version you see their joint conference of Windows before was Lotus was just about 3 5 is converted the database to a person for 5 and courses also right on a basis for another SQL Server 2002 SQL Server comic edition 2005 situation

Minute 11
In the previous example the conversion to but if the city doesn t went so easily because their database was not encrypt it was simply a story for no encryption we know that in real production applications and Neil a large number databases need to be encrypted data secure will see that we upgraded the city to does a still a pretty job for us but we do need to do one after step to make everything work together in case of datagram at a price we have your simpleminded cf with SQL Server compact is a five encrypted and struck that barrier with the Golden gun so this guy comes up to willing to get into same price if we had the key difference is that this database now is past protected and encrypted and so eventually a look inside here an assertion or password urgency

Minute 12
And password you can see that the password is stored here is a fast recession set the word password one thing closes out I get in Ryan ready to run find them a 2005 particular places do their oldest run for Jesus you run just fine here gets running on its SQL Server contractor for no who does again seems closer to those of our competition as as as as as guy and now instead an open of Visual Studio two dozen eggs will close this 22 dozen eight and will now get out of that same project in the sky of the lunar to save file open project in the navigator to our won t be encrypted database to open up the solution right away in the wizard of adults is a one of greatest guy to sit next was a good good backup copy or a drop in the same location

Minute 13
Sit next the inside cells was a new was a finish and goes through those thing when so I guess although still a subversion log here is to close on their it is the most versions are really well except one did we have one conversion failed here and as the database file itself because the file is encrypted the actual literacy to does the upgrade Wizard cannot upgrade a force so if I try to run this site by federal run this having it of this old database format with a stuffed visit expected right to the excesses as it is files are created by early version of SQL Server compact and now we do have to do initiative correct is the best of his antiquities is as good stopper devoting closes window appears also to bat it was reported well so we can do now is this open up

Minute 14
Exporter is to view server Explorer as it when the automatic connections or navigate out to the date is lower using a severe to my computer in a number of envious projects folder is just encrypted one sorted out here and open up that database telephone single click before you do just that we upgraded this project decree of backup folder and at back of full or has back about everything including the database or databases already backed up with you as important as moment is the lack of your regular down and now go down and try open up our current database and we say Olson and we get you the password for a pass for PAS is the view of RD one and we said okay to sit in the the upgrade is the true 5 is okay as a steadfast information visit to false the applet name is seen as a source name so what do you do

Minute 15
Either modify the output name or say it s okay to overwrite the original file directories I pointed out that party resorted backup is that music scene for us to go ahead and overwrite the existing file because I have been a project we are back to database race now is it okay these several go ahead and do Davis conversion force as we take a look here as you don t look inside Arial the tables everything I said now she ll run the project in addition of a there to see now is running a business or a compact version 3 5 and older is working fine now this is a key extra step was simply opening up of the database in server Explorer and letting it goodness of grated resource will be a less for

Minute 16
A cat is also the most involved again now offering a project vigil 60 005 visit to sue 2008 and a project uses a SQL Server CE EE 2 0 database the complication areas that SQL Server competition 2005 verse six or 2005 product edition had desktop support effect desktop utilities handle the upgrade for your SQL Server CE 2 0 did not have desktop support and as a result you how to do the database upgrade on a device or on an emulator to the overall operating process is just that it was in our previous case and where we actually use Visual Studio to does need to upgrade everything for surprise at the labyrinth everything and that we do the extra step to upgrade the database but in this case rather than do it through servers for Visual Studio two dozen eight West duo would be a commandline till

Minute 17
Being a grain XE for this artist is things we have to do basically you just saw several things onto our device or emulator going to work for us now is first CF installed is a lot of rarities for the version of SQL Server CE or start from her and asked our case is to point out right so we went here s not find those first resident or my computer and under program files noted under tour Visual Studio two Visual Studio eight rate of sex abuse to 2005 Toledo and to their guns smart devices and deleted a statistic in a SQL Server mobile 2 0 and of using Windows will file in Middlesex here to receive 500 device over 400 km all window seat us know what is mobile devices are processors so we need is

Minute 18
To solve that Far right are onto the device or emulator for the Rio courses if the sky cradled in copy files to the resolute and bring up a device similar manager cradle is gone it was it s all cradled we can actually use Explorer does not sank to get to raise to two years in click through to just do a guest partnership is that there is canceled as file folder or it s just now get toys in Toronto a bagel to explore not exploring the sticker emulator you for these files anywhere you want because them for a temporary action just deliver some rum wants a life of its easier for the very top of the whole Fossett is because of the is located like later to do this take the SQL CE 2 0 stuff copied over to the emulator

Minute 19
That copies over what gets there will do the install location now that s a stall on its US confidant of the emulator now do the actual install programs value to wood forest floor two of the words that this was click on that guy in the digestion environment in case that s not sorted their necks in the install is the libraries we need for the destination database rooms or SQL Server contract 3 5 now we have a choice in this of you can manually copy over the various Files say what those are posted as an easier way so one day you re going to manually do this and to appear demise of time if you are in the midweek SQL Server systems for competition

Minute 20
V3 5 go into her devices down to receive 500 and we give to our arms of your beta from here with the copy and respect of several things recovered a Pocket PC flood File for it was a copy of the developer stuff for Pocket PC or rather companies are won by one guy she open off of his litigious individual city 2000 a project that every has the proper references for SQL Server contract for 25 Rice likened to hear his erratic carpet is over and saw the one by one of the go out here and grab one of the projects we were recovered as we are just grabbed when it s yet for SQL Server contract 2005 was the oil to get the own open up and without it and there is a little ploy that project

Minute 21
Is supposedly going build the ploy that will now copy everything is required these SQL Server contract 3 5 accidentally cases and insulted as a fully completed for us and we can see here that that took care of copping out there and installing all of the SQL Server compact 3 5 phosphorous residents we go over to her emulator now and we take a look all here into our settings system so programs will see that we got in our SQL CE 2 0 installed as well as all the SQL Server competent and five tools and environment so that s their force in the next that we need to do is actually get the proper upgrade utility out there for us and so I head back to her program files area than it is here that same folder under SQL Server

Minute 22
Often 3 5 is asked to the upgrade that is the best utility will actually do the upgrade force just need to get back onto our emulator does is go back to the folder that represents her device emulator that here s a copy that guy over there it s that s they re so good utility there and finally we need a database so I ve done here is that here in obvious projects folder as that of Earth or North land of the taxi sequels the SQL Server CE 2 0 database so do this one is inside and copy as well that was human mind when you do these conversions is that because you know the conversion all in the device of artist is the emulator you going to need to have enough storage for basically two kinds of data to its right source version and then of course the final version is that I was a teen challenges in doing this is making sure that you

Minute 23
Turn a pacifist storage and handle the upgrade of the database for looking out this point your device driver later is all set to get source libraries if the destination libraries you got the upgrade utility view metadata which would convert it in the interior is really run the upgrade utility of course one of the challenges is that Windows will devices only have a command line virus you can issue commands directory from the actual debarment aside of Woods Hole to the city do your who wanted to we can actually struggle a little seizure are for VB net program that does use the process class to start the commandline to do the upgrade for us unfortunately we are in an accessible utility will do all that work for us if I go out here to a browser and to transient page I do a search for them

Minute 24
Windows mobile developer possibly helped our choice that you got it right there if Windows mobile developer are to ask those it is now too little download here got a download and moved down here this is just a regular withholds com and download stage an adherent gotten Windows mobile developer power toys range from here you can download of this installation will give you access to a number of different tilt is the one that we like this is just happy start that he allows us to issue a command line from our desktop computer and had a command executed over on the device or emulator or so you would do this guy of course is just it to download files useful to set when your little hearts with them as I see download a file in the US

Minute 25
All it wants is installed you find at your programs all for a very here for you now have a Windows mobile developer power toys folder as we go into their will see of course we get to wrap the start holiday and careful of its look into using the folder name is crappy artists were start to programming as a scrappy start still will lead you now recently got here is a commandline and get that there is but a change directorate of their synthetic copy that adheres to the old space at its least enter the number in that area is now I just run around the start and this is a wrapping start and know what I want to start over with everything as a top level of the emulator

Minute 26
And it has just given it to them on arguments been so maybe i is that this last asks for whatever the source is going to be resource file strikers at the top level for some of my Northwind 20 SDF file if a source password to put that in your and then I might destination file with program to 3 5 social Northwind 35 us TE enough to have a destination password or that I would go years well can we take those guys often honestly have the data was encrypted and subdue that their Sorrells set ranges of rowdy start it for aware run up to test the argument since as maturity at my do the steps of director and it is now almost said that he does to

Minute 27
Ted and Rob may suit launched programs that will is at this point conversion wives began running on the emulator right novellas for a fair longer time when it s done so just did a message box telling it is completed if this fails for any reason will be an upgrade dialogue file right there at the top level as well and whenever the conversion finishes you just copied upgrade database backed for your project expects it in a fur trimmed and Ron is the key thing here is just getting your device and later set of you actually manually one be upgraded to all the rest of processes just redid it is to the past step The encrypted database file which is using a different upgrade until it covers everything with the upgrades there when he was two wells and present it is incorporated by three time

Click here to go to original video page