Learn how to a build a cloud-first strategyRegister Now

x
  • Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 210
  • Last Modified:

Pocket PC Development - RDA - General

Experts,

I am developing an application for Pocket PC that will house data in a local CE database on the Pocket PC.  I have a few question before I finalize my approach; I plan to use RDA (Pull and Push) from and to a Master SQL 2005 database hanging off a DMZ; the IIS server will also hang off the same DMZ and will be accessible from the outside world by a global address (no DNS).  My question is during the RDA Pull, can I bring over the database structure only from the Master SQL 2005 server (no data)?

Secondly, I have yet to receive the Pocket PC model that will be used and I have to use the VB2005 emulator; how can I get the pocket pc to see the IIS (sqlcesa30.dll) website?  It is posing quite a challenge in the beginning stages of the design.  I am unable to test the RDA functionality because the pocket pc emulator cannot access the IIS server via the browser.

Lastly, could you provide me with an example of the (3) connection strings that I will need in the application (to master 2005 DB, to local pocket PC DB, etc)

Your Assistance is GREATLY appreciated.
0
NCSO
Asked:
NCSO
1 Solution
 
Mikal613Commented:
1) My question is during the RDA Pull, can I bring over the database structure only from the Master SQL 2005 server (no data)?

1) http://www.codeproject.com/dotnet/ScriptDiagram2005.asp  <-- perhaps you can script the schema and then send the file.

2)You just type in the address to the Pocket browser
0
 
NCSOAuthor Commented:
That URL is for building a database diagram.
0

Featured Post

[Webinar] Cloud and Mobile-First Strategy

Maybe you’ve fully adopted the cloud since the beginning. Or maybe you started with on-prem resources but are pursuing a “cloud and mobile first” strategy. Getting to that end state has its challenges. Discover how to build out a 100% cloud and mobile IT strategy in this webinar.

Tackle projects and never again get stuck behind a technical roadblock.
Join Now