Mobile sdf File created on Server

Hi there,

Background: I've created an application to run on windows mobile 5.0 devices. It replicates to a publication on a server. To do this it goes through ASP.net. This creates the database on the Mobile Devices.

Issue: Problem is the initial download of the database is taking 2hours plus to replicate (create) for the first time. So I'm trying to create the .sdf file on the server, zip it, and send it across to the handheld. All subsequent replications take about 5 minutes.

Question: Does anyone know how, or have examples for creating a Mobile CE database on the server. I need to create it using ASP.net and go through a pre-existing publication where a hostname used for filtering.

http://msdn2.microsoft.com/en-us/library/ms173009.aspx explains how to create this in SQL Server Management Stuidio. How do you do the same thing over ASP?

Can this be done using SMO? How do you create a SQLServerCompactEdition database using normal .NET Framework? Thanks for your help!!

Is it possible to access System.Data.SqlServerCe namespace without using the .NET Compact Framework?

So if I wanted to access the assembly in a VB.NET Windows App inside the .NET Framework, is this possible?

|||

Yes, SQL CE 3.1 allows you to do that. There’s a special version of SQL CE provider for desktop framework.

|||You can run code like in this sample (http://msdn2.microsoft.com/en-us/library/system.data.sqlserverce.sqlcereplication.synchronize.aspx

on your web server. create the file to the local file system and zip it. Then give the device the URL to the .zip file and your .NET Compact Framework app can the download the .zip file using HttpWebRequest class and unzip.

|||

So the problem i was having was in using an assembly that came with the compact framework. The System.Data.SqlServerCE.dll file is located in at least two places on my machine. One in the CE and one in the Common folder...both have the same name and version number.

I changed the reference from pointing at the CE version to the normal version and it cleared up the problem. Thanks for the responses, I'm still not sure what the differences in the assemblies are.

Mobile sdf File created on Server

Hi there,

Background: I've created an application to run on windows mobile 5.0 devices. It replicates to a publication on a server. To do this it goes through ASP.net. This creates the database on the Mobile Devices.

Issue: Problem is the initial download of the database is taking 2hours plus to replicate (create) for the first time. So I'm trying to create the .sdf file on the server, zip it, and send it across to the handheld. All subsequent replications take about 5 minutes.

Question: Does anyone know how, or have examples for creating a Mobile CE database on the server. I need to create it using ASP.net and go through a pre-existing publication where a hostname used for filtering.

http://msdn2.microsoft.com/en-us/library/ms173009.aspx explains how to create this in SQL Server Management Stuidio. How do you do the same thing over ASP?

Can this be done using SMO? How do you create a SQLServerCompactEdition database using normal .NET Framework? Thanks for your help!!

Is it possible to access System.Data.SqlServerCe namespace without using the .NET Compact Framework?

So if I wanted to access the assembly in a VB.NET Windows App inside the .NET Framework, is this possible?

|||

Yes, SQL CE 3.1 allows you to do that. There’s a special version of SQL CE provider for desktop framework.

|||You can run code like in this sample (http://msdn2.microsoft.com/en-us/library/system.data.sqlserverce.sqlcereplication.synchronize.aspx

on your web server. create the file to the local file system and zip it. Then give the device the URL to the .zip file and your .NET Compact Framework app can the download the .zip file using HttpWebRequest class and unzip.

|||

So the problem i was having was in using an assembly that came with the compact framework. The System.Data.SqlServerCE.dll file is located in at least two places on my machine. One in the CE and one in the Common folder...both have the same name and version number.

I changed the reference from pointing at the CE version to the normal version and it cleared up the problem. Thanks for the responses, I'm still not sure what the differences in the assemblies are.

sql

Missing Transactions

SQL 2k & Win 2k
I have a server(S1) that has a trans. publication of 4 tables. I have
another server (S2) that has a subscription to the publication on S1. This
works fine.
Now, S2 has a merge publication of the same 4 tables to several remote
locations. I have a filter in the publication on each of the the four tables
that filters on a numeric field (ex. loc = 19). If I reinitialize the
subscription, only the data that meets the filter clause is populated on the
subscriber.
SO here is the problem....When data is inserted into S1, it makes it to S2,
but not to the remote locations.
If I do a validation, on S2, I get the error... Article 'TableName' failed
data validation (rowcount only) this message appears for each table.
If I insert a row manually into one of the tables on S1 & run the
distribution & merge agents manually, the row makes it to the final
destination, well on the one test I did.
TIA,
Larry...
Is there anything logged in your conflict tables? Use the conflict viewer to
tell.
Hilary Cotter
Looking for a SQL Server replication book?
Now available for purchase at:
http://www.nwsu.com/0974973602.html
"Larry" <Larry@.discussions.microsoft.com> wrote in message
news:6EB8F35D-7D55-468D-AEBB-5209D1A406F5@.microsoft.com...
> SQL 2k & Win 2k
> I have a server(S1) that has a trans. publication of 4 tables. I have
> another server (S2) that has a subscription to the publication on S1.
> This
> works fine.
> Now, S2 has a merge publication of the same 4 tables to several remote
> locations. I have a filter in the publication on each of the the four
> tables
> that filters on a numeric field (ex. loc = 19). If I reinitialize the
> subscription, only the data that meets the filter clause is populated on
> the
> subscriber.
> SO here is the problem....When data is inserted into S1, it makes it to
> S2,
> but not to the remote locations.
> If I do a validation, on S2, I get the error... Article 'TableName' failed
> data validation (rowcount only) this message appears for each table.
> If I insert a row manually into one of the tables on S1 & run the
> distribution & merge agents manually, the row makes it to the final
> destination, well on the one test I did.
> TIA,
> Larry...
|||When I 'View Confilcts', there are <no confilict tables>.
Larry...
PS - got my book yesterday...thanks!
"Hilary Cotter" wrote:

> Is there anything logged in your conflict tables? Use the conflict viewer to
> tell.
|||Also, when I look at the 'Merge Agent History', there have been no
transactions replicated today, but I know there has been some data that has
been moved from S1 to S2.
|||I'm drawing a blank on this one. I'd contact PSS on this. Hope you enjoy the
book.
Hilary Cotter
Looking for a SQL Server replication book?
http://www.nwsu.com/0974973602.html
"Larry" <Larry@.discussions.microsoft.com> wrote in message
news:7231045F-D1B7-4EF3-9FC1-8A6EF303065D@.microsoft.com...
> Also, when I look at the 'Merge Agent History', there have been no
> transactions replicated today, but I know there has been some data that
> has
> been moved from S1 to S2.
>

Missing Subscriber tab in EM Replication Configure wizard

Hi All,
On a server I configured publication of a database and push subcriptions
successfully using Enterprise Manager. But later when I select the
"Configure Publishing, Subsribers and Distribution" option again by either
right clicking on Replication folder or Menu, I find Subscribers tab is
missing, I see only Distributor and Publishers tabs.
Can anyone please tell me what I am missing anything here?
Thanks a lot,
VM
The server is not configured as a publisher. Enable it as a publisher and
click apply and ok. Reopen this dialog.
Hilary Cotter
Looking for a SQL Server replication book?
http://www.nwsu.com/0974973602.html
Looking for a FAQ on Indexing Services/SQL FTS
http://www.indexserverfaq.com
"VM" <VM@.discussions.microsoft.com> wrote in message
news:8C3C9EA9-B273-4CA6-99BF-CA51B6E25294@.microsoft.com...
> Hi All,
> On a server I configured publication of a database and push subcriptions
> successfully using Enterprise Manager. But later when I select the
> "Configure Publishing, Subsribers and Distribution" option again by
> either
> right clicking on Replication folder or Menu, I find Subscribers tab is
> missing, I see only Distributor and Publishers tabs.
> Can anyone please tell me what I am missing anything here?
> Thanks a lot,
> VM

missing object warning when adding column to table with sp_repladd

Added a column to one table with sp_repladdcolumn in publisher/distributor.
This warning comes from every publication this table belongs to:
Cannot add rows to sysdepends for the current stored procedure because it
depends on the missing object 'sp_sel_C245F32C38A611D525494BFC6FD140A7_pal'.
The stored procedure will still be created.
In use: Merge replication and static filtered publications referencing this
table.
Is it safe to continue and trust that everything works after this? What is
this _pal ending sp? What happens if it does not exist and what should we do
next?
Thanks - M
Its fine as long as this proc is present in all subscribers.
Hilary Cotter
Looking for a SQL Server replication book?
http://www.nwsu.com/0974973602.html
Looking for a FAQ on Indexing Services/SQL FTS
http://www.indexserverfaq.com
"Untamo" <Untamo@.discussions.microsoft.com> wrote in message
news:0BC7CA5F-872E-4AB9-B1EB-F0ADCDD435B6@.microsoft.com...
> Added a column to one table with sp_repladdcolumn in
publisher/distributor.
> This warning comes from every publication this table belongs to:
> Cannot add rows to sysdepends for the current stored procedure because it
> depends on the missing object
'sp_sel_C245F32C38A611D525494BFC6FD140A7_pal'.
> The stored procedure will still be created.
> In use: Merge replication and static filtered publications referencing
this
> table.
> Is it safe to continue and trust that everything works after this? What is
> this _pal ending sp? What happens if it does not exist and what should we
do
> next?
> Thanks - M