Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
| Author |
Topic |
|
groston
Yak Posting Veteran
61 Posts |
 Posted - 2005-05-03 : 23:26:33
|
| I have a database on my desktop machine. I would like to copy it to my PocketPC.I can purchase a $50 tool to do this (oberkill for my current purposes) or I can spend a bunch of time trying to figure out replication (too much work for now).What I would like is a freeware tool (or script) to do this. Does such a beast exist? Would you please direct me to it?Thanks! |
|
|
spirit1
Cybernetic Yak Master
11752 Posts |
Posted - 2005-05-04 : 04:17:58
|
how about some simple insert into PocketPcTable(columns you want to insert)select columns you want to insertfrom DesktopTablehow many tables do you have anyway??Go with the flow & have fun! Else fight the flow  |
 |
|
|
groston
Yak Posting Veteran
61 Posts |
Posted - 2005-05-05 : 09:31:54
|
| Your idea is a good one, but I do not know how to do this. The PPC does not show up in Enterprise Manager as a server. Also, I am not sure how I would have to configure my systems to do this from the Query Analyzer on the PPC.If you can provide more details, that would be great.p.s. About 6-8 tables - not many, but some are quite large |
|
|
|
spirit1
Cybernetic Yak Master
11752 Posts |
Posted - 2005-05-05 : 10:02:38
|
| you'll probably have to set up linked server between PPC and your desktop PC.read about sp_addlinkedserver in BOL = Books Onlike = SQL server helpGo with the flow & have fun! Else fight the flow |
|
|
|
groston
Yak Posting Veteran
61 Posts |
Posted - 2005-05-05 : 10:15:16
|
| Do you know if this will work? My understanding is that the SQL Server CE communicates with SQL Server using IIS. As such, it seems as if creating a linked server wouldn't work. Also, when creating a linked server, there is no option for a SQL Server CE data connection. |
|
|
|
spirit1
Cybernetic Yak Master
11752 Posts |
Posted - 2005-05-05 : 10:19:29
|
| no i don't know if it will work. i never tried it...it was suggestion. it's the first time i heard it communicaters through iis though...hopefully someone else has some idea...emm and how did you think about doing replication when you can't connect the servers??Go with the flow & have fun! Else fight the flow |
|
|
|
groston
Yak Posting Veteran
61 Posts |
Posted - 2005-05-05 : 10:24:20
|
| Actually, for this application, replication is not needed. The intended product is for handheld use only.Thanks for your suggestions! |
|
|
|
|
|
|
Copying data to PocketPC (SQL ServerCE)