Does anyone have any instructions on how to go about uprading a .sdf file
from sqlce 2.0 to sqlce 3.0
I found this on an msdn website
(link: http://www.microsoft.com/sql/editions/sqlmobile/upgrading.mspx) but
as you can see its very lacking on detail. (I included the link and content
referring to upgrading the database files so you won't have to go to the link
to see the part referring to upgrading the database.) I tried to run the upgrade.exe on my device but it doesn't explain how you're supposed to point it to the .sdf that you are trying to update. Here is the content on the above web page.
Upgrading Database Files
You can upgrade a database created with an earlier version of SQL Server CE
2.0 to a database created with SQL Server Mobile by using the SQL Server
Mobile Database Upgrade tool (upgrade.exe). The Database Upgrade tool runs on
a smart device.
When you run the SQL Server Mobile Database Upgrade tool, the new SQL Server
Mobile database is created on the smart device. The new database, with the
file name extension .sdf, contains all the data that was in the source
database. You need to reinitialize the upgraded database to continue using it
for replication.
Note: If you are using replication or remote data access (RDA) as a
connectivity solution before upgrading to SQL Server Mobile, you must
synchronize the source SQL Server CE database (subscription database) with
the SQL Server database (Publisher). The reason for synchronizing before
upgrading to SQL Server Mobile is to ensure that any changes that exist in
the tables on the SQL Server CE database are updated on the SQL Server
database, because after the upgrade you must resubscribe or repull using the
new database.
How do you use the upgrade.exe for sqlce 2.0 to sqlce 3.0?
Hot Topic
- Where to color Line Graph lines?
- DateTime parameter format
- Database Mail Setup
- Creating aomething similar like SCD wizard interface
- SQL Server 2005 Management Studio error when open connection to remote SQL server
- Dynamically modifying flat file connector based on variable header row
- Reporting
- Linked Server problem when querying
- 'provider not found or it may not be installed properly error' in analysis services
- Access DB2 on AS/400 using IBM OLE DB Provider
SQL Server
- international db
- updating a data table when a row has been deleted or added
- Schema versioning - change schemaLocation, but keep same namespace ?
- Timeout error while copying database (Sql Server 2005)
- Triggering Data Driven Subscription
- Setting SQL server Express maximum memory usage
- Performance Question about: ExecStoredProcedure with ATL OLEDB Consumer Templates.
- How can I create, change Database diagrams in 2005?
- Concatenation of Dimension Table fields in MDX
- Relational data via UDM in AS2005?
How do you use the upgrade.exe for sqlce 2.0 to sqlce 3.0?
SteveInHampshire
This one should help:
http://msdn2.microsoft.com/en-us/library/ms171803.aspx
trknssr
Thank you! There was another link (http://msdn2.microsoft.com/en-us/library/ms173006.aspx) with specific instructions about the actual run command, but the link you sent had some requirements that were helpful. Especially since I had already removed SQLCe2.0 from my device and had to reinstall it to use the update.exe tool. Thanks again!
Rob