Showing posts with label offline. Show all posts
Showing posts with label offline. Show all posts

Friday, March 23, 2012

How to use SQL Express to Cache the data.

Hi,

We are using VSTO 2005 and developing an Ms-Office Excel application which has to work both in Online and Offline. When the user connects to office LAN network then the data that the user will use data comming from our centralised database. This is for online scenario but when the user is in offline i.e. when the user is out of office user has to use the data which comes from the SQL Express. Once user connects to office LAN all the data from SQL Express has to be automatically synch with centralised database.

How to catch the data into SQL Express in stead of using the default Caching data into DataSets for working in offline mode. Please kindly help me in order to solve this issue.

Thanks in advance,

Hello:

I've moved your question to the SQL Server Replication forum, as your issue seems to be more in their domain.

Thanks!

Mike Hernandez
Community PM
VSTO Team

|||

You could make the SQL Express as a merge subscriber to the Central Server. When connected, the middle tier can make the user talk to the Central Server directly and when offline, the middle tier needs to connect the user to the SQL Express instance.

When connected to the Central Server, Merge replication can keep changes in sync and when offline, changes can happen at the Central Server and SQL Express independenlty and when connection is restore, the changes will be synched across.

You will need to take into account if you are going to have conflicts and if so, an appropriate resolver.

Please see Books Online for more information.

How to use sql express in offline mode for report generation ?

Hi , I have been using ms sql 2000 database for generating reports up till now . but now as per a new requirement , i have to obtain data for generating the report from sql express & not ms sql 2000 , and that too in offline mode . i do not know how the structure of data is there in sql express . 1)do we have data stored in tables? or do we use xml ? 2)do we write similar queries as we write in ms sql ?? 3) and lastly what is this offline stuff ? Can any one please throw some light on comparison between sql 2000 and sql express in these three points. Thanks in advance

>I do not know how the structure of data is there in sql express . 1)dowe have data stored in tables? or do we use xml ?
Data is stored in tables as in SQL2000 or SQL2005 - the limitation is on the size of the database. You can also use XML when in

2)do we write similarqueries as we write in ms sql ?
Just the same!


3) and lastly what is this offlinestuff ?
Offline refers to getting data from a ource other than SQL Server (which includes SQL 2005 Express)

sql

Wednesday, March 21, 2012

How to use SQL Express to Cache the data.

Hi,

We are using VSTO 2005 and developing an Ms-Office Excel application which has to work both in Online and Offline. When the user connects to office LAN network then the data that the user will use data comming from our centralised database. This is for online scenario but when the user is in offline i.e. when the user is out of office user has to use the data which comes from the SQL Express. Once user connects to office LAN all the data from SQL Express has to be automatically synch with centralised database.

How to catch the data into SQL Express in stead of using the default Caching data into DataSets for working in offline mode. Please kindly help me in order to solve this issue.

Thanks in advance,

Hello:

I've moved your question to the SQL Server Replication forum, as your issue seems to be more in their domain.

Thanks!

Mike Hernandez
Community PM
VSTO Team

|||

You could make the SQL Express as a merge subscriber to the Central Server. When connected, the middle tier can make the user talk to the Central Server directly and when offline, the middle tier needs to connect the user to the SQL Express instance.

When connected to the Central Server, Merge replication can keep changes in sync and when offline, changes can happen at the Central Server and SQL Express independenlty and when connection is restore, the changes will be synched across.

You will need to take into account if you are going to have conflicts and if so, an appropriate resolver.

Please see Books Online for more information.

How to use SQL Express to Cache the data.

Hi,

We are using VSTO 2005 and developing an Ms-Office Excel application which has to work both in Online and Offline. When the user connects to office LAN network then the data that the user will use data comming from our centralised database. This is for online scenario but when the user is in offline i.e. when the user is out of office user has to use the data which comes from the SQL Express. Once user connects to office LAN all the data from SQL Express has to be automatically synch with centralised database.

How to catch the data into SQL Express in stead of using the default Caching data into DataSets for working in offline mode. Please kindly help me in order to solve this issue.

Thanks in advance,

Hello:

I've moved your question to the SQL Server Replication forum, as your issue seems to be more in their domain.

Thanks!

Mike Hernandez
Community PM
VSTO Team

|||

You could make the SQL Express as a merge subscriber to the Central Server. When connected, the middle tier can make the user talk to the Central Server directly and when offline, the middle tier needs to connect the user to the SQL Express instance.

When connected to the Central Server, Merge replication can keep changes in sync and when offline, changes can happen at the Central Server and SQL Express independenlty and when connection is restore, the changes will be synched across.

You will need to take into account if you are going to have conflicts and if so, an appropriate resolver.

Please see Books Online for more information.

How to use sql express in offline mode for report generation ?

Hi , I have been using ms sql 2000 database for generating reports up till now . but now as per a new requirement , i have to obtain data for generating the report from sql express & not ms sql 2000 , and that too in offline mode . i do not know how the structure of data is there in sql express . 1)do we have data stored in tables? or do we use xml ? 2)do we write similar queries as we write in ms sql ?? 3) and lastly what is this offline stuff ? Can any one please throw some light on comparison between sql 2000 and sql express in these three points. Thanks in advance

>I do not know how the structure of data is there in sql express . 1)dowe have data stored in tables? or do we use xml ?
Data is stored in tables as in SQL2000 or SQL2005 - the limitation is on the size of the database. You can also use XML when in

2)do we write similarqueries as we write in ms sql ?
Just the same!


3) and lastly what is this offlinestuff ?
Offline refers to getting data from a ource other than SQL Server (which includes SQL 2005 Express)

sql

How to use sql express in offline mode for generating a report !!

Hi ,

I have been using ms sql 2000 database for generating reports up till now . but now as per a new requirement , i have to obtain data for generating the report from sql express & not ms sql 2000 , and that too in offline mode . i do not know how the structure of data is there in sql express .

1)do we have data stored in tables? or do we use xml ?

2)do we write similar queries as we write in ms sql ?

3) and lastly what is this offline stuff ?

Can any one please throw some light on comparison between sql 2000 and sql express in these three points.

Thanks in advance

SQL Express is the exact same database engine as SQL Server. SQL Express has maximum database size limits (4 GB), and some other functionalities are not included, but generally, you use it the same. Same tables, VIEWs, queries, security, etc.

As to the 'off-line'. I 'm not sure what you mean, but I suspect the requirement means to not allow data changes while the report is being generated. An 'Off-line' database is generally not available -it is off-line. (Go figure...) You could restrict usage by changing the database to 'Read-Only' or to 'Single User' mode. More information is needed to give a definitive response to that part.

Click here for a more detailed contrast between the versions.

|||

In addition to Arnie, you don′t need a database for generating reports in SQL Server Reporting Services. the reports can also be based on XML files or any other providers shipped with SQL Server. For SQL Server Express, you can only use local SQL Server data (stored in tables)

Jens K. Suessmeyer.


http://www.sqlserver2005.de