SQL Server 2005 Replication and views

Question

Hi,

I read that views can't be published with SQL Server 2005 replication. Is this planned for the future? If not what alternatives are there for this?

Simple collecting the data needed in a new table ain't a solution for us (memory consuming). And joining the data on the PPC ain't a good solution either (memory and time consuming). We only want to pull the data.

Greets,

Ivo Klerkx

Answer 1

Just to confirm your statement, it is true that (other than the INFORMATION_SCHEMA views) there is no support for other user-creatable Views in SQL Mobile, whether they are created on device or on the server/replicated.

Microsoft would have to comment on plans to include this in the future, but what most people are doing today to simulate the functionality of a view is to use DataSets in memory with custom schemas and adapters that pull necessary data from source SQL Mobile Tables.  Yes, you have to be smart about using this approach to minimize the amount of memory consumption on device, but this approach can be made to work well and performs very well.

-Darren

 

Answer 2

Is there no solution on the server side? We prefer to leave the complexity on the server side and not on the client side. I guess the only solution is to use stored procedures to make a new table and keep this one up to date when the "normal" (referenced) table's change. Or hopefully views are added in the future.

Other suggestions are more then welcome.

Ivo Klerkx