This is the scenario.
We have one or more laptops that might never be connected to a network. We want to be able to save the data from the server to a USB drive, take the USB drive to a laptop and import the data. We also need to be able to send the data from the laptop to the server the same way (using USB drives) since the data on the laptop have been update/changed or deleted.
Is this even possible, and how do we do it using replication (if possible)?
If it si not possible, what other options do we have?
GeorgeUsually replication works between servers. In you case try to use DTS.|||Originally posted by snail
Usually replication works between servers. In you case try to use DTS.
Would DTS be able to Merge the data between the 2 servers? If so, how do I do it?|||Originally posted by gehrlekrona
Would DTS be able to Merge the data between the 2 servers? If so, how do I do it?
You cold import (export) data from USB drive and merge data by using special stored procedure - it depens on logic of moving your data.
2012年3月20日星期二
Disconnected Mirror / In Recovery
Hello,
I'm having a problem with two mirrored databases, using SQL Server 2005 SP2, that autmatically failed over last night for unknown reasons. I was trying to fail them back over to the primary SQL server because it says the mirror is disconnected and out of sync. Other databases failed over too, but I was able to fail those back over without a problem. It's just these two. I removed the mirror from the secondary server thinking that this would allow me to restore the database back on the primary server, but that didn't help.
These two databases show a status of (Principal, Disconnected / In Recovery) and I still cannot do anything with the two databases on the primary server. When I try to pull up the properties for them, I get the following error:
"Database <Name> is enabled for Database Mirroring, but neither the partner nor the witness server instances are available: the database cannot be opened.(Microsoft SQL Server, Error: 955)"
I cannot delete, detach, Alter or do anything with the databases. If I could just delete them that would be fine so I can just do a restore, but I can't seem to do anything.
Does anyone know what I can do to resolve this problem.
Thanks in advance!
-Jay
I was finally able to get the two databases to come back up online. I was trying so many different things, I 'm not sure which one, or combination, fixed it. But I checked the processes and there was one process running on one of the databases so I killed it. It seemed to come back right away, but after that, I was able to detach the DB. I reattached it and both of the databases came up with an online status.
I hope this helps.
-Jay
|||This sounds similar to problems I have had (see my post below on split brain). I too had to kill connections to the principal in order to do anything to fix it, it went into recovery when I tried to remove mirroring and all users were disconnected.
I think this is very undesirable. There is no way both nodes should ever be the principal. If failover happens, it should either complete or not, there should be no half way, whatever the mode of failure.
|||Sound like it, also mention what kind of configuration mode you are using for DB Mirroring.
As suggested referring to witness server log will helps a bit to see what is going on.
disconnected import-export
Hi everybody,
I have the following problem: I have a very large data base used by our
clients for beta-testing. With prohibitions of just taking the data (using a
backup or so)
I can connect to this machine by accesing two terminal service - poor
network performance so on.
I have to take data out of this database - to have a proper "seed" for our
load test scenarios.
I tried bulk copy - well, I still have some problems with the inserts in our
database, but I am wondering wether is there a better way of automating the
task of exporting every table to a file using bcp - here comes the problem
wether I need a format file for every table)
Maybe I can achieve the same result in a more elegent way with DTS packages?
Is there a way to do this disconnected import export operation using dts and
some intermediery text/binary files that I can move between the machines?
Any help is welcomed,
Andreandrea,
Regarding moving data from one machine to another with bcp, you do not need
a format file for every table if: you:
1. Choose an overall format -c (character mode) or -n (native mode)
2. The table definitions between servers are identical.
Following is an example xfer.cmd file
-- BCPXFER.BAT
REM Parms %1=SourceServer %2=TargetServer %3=DatabaseName %4=TableName
%5=LogPath
bcp %3..%4 out \\Server\Xfer\%4.dat -c -S%1 -T -e%4-bcpout.log >> %5bcp.log
osql -S%1 -Q"truncate table %3..%4" -E >> %5bcp.log
bcp %3..%4 in \\Server\Xfer\ -c -S%2 -T -e%4-bcpout.log >> %5bcp.log
--
This makes some assumptions:
1. TRUNCATE TABLE will work on your target server, so there cannot be any
foreign key constraints for that to work. If there are FK constraints, you
will need to change to "delete table"
2. One trusted connection works on both servers. If this is not the case,
you will need to add more login information (including passwords) to the
parameter list.
3. Both servers can reach the same file share. If this is not true, then
you will need to insert a copy file step between the bcp out and the bcp in.
Etc. etc.
This is not a full solution for you, since there are many unknowns, but if
this works you then create a higher level BAT file in the form:
-- MyXfer.BAT
call bcpxfer.bat Server1 Server2 MyDatabase MyTable1 MyLogPath
call bcpxfer.bat Server1 Server2 MyDatabase MyTable2 MyLogPath
call bcpxfer.bat Server1 Server2 MyDatabase MyTable3 MyLogPath
RLF
PS - Are you the same person as Andrea Anastasescu?
"andrea" <a@.a.a> wrote in message
news:ex%23SKyB5HHA.464@.TK2MSFTNGP02.phx.gbl...
> Hi everybody,
> I have the following problem: I have a very large data base used by our
> clients for beta-testing. With prohibitions of just taking the data (using
> a backup or so)
> I can connect to this machine by accesing two terminal service - poor
> network performance so on.
> I have to take data out of this database - to have a proper "seed" for our
> load test scenarios.
> I tried bulk copy - well, I still have some problems with the inserts in
> our database, but I am wondering wether is there a better way of
> automating the task of exporting every table to a file using bcp - here
> comes the problem wether I need a format file for every table)
> Maybe I can achieve the same result in a more elegent way with DTS
> packages? Is there a way to do this disconnected import export operation
> using dts and some intermediery text/binary files that I can move between
> the machines?
> Any help is welcomed,
> Andre
>
I have the following problem: I have a very large data base used by our
clients for beta-testing. With prohibitions of just taking the data (using a
backup or so)
I can connect to this machine by accesing two terminal service - poor
network performance so on.
I have to take data out of this database - to have a proper "seed" for our
load test scenarios.
I tried bulk copy - well, I still have some problems with the inserts in our
database, but I am wondering wether is there a better way of automating the
task of exporting every table to a file using bcp - here comes the problem
wether I need a format file for every table)
Maybe I can achieve the same result in a more elegent way with DTS packages?
Is there a way to do this disconnected import export operation using dts and
some intermediery text/binary files that I can move between the machines?
Any help is welcomed,
Andreandrea,
Regarding moving data from one machine to another with bcp, you do not need
a format file for every table if: you:
1. Choose an overall format -c (character mode) or -n (native mode)
2. The table definitions between servers are identical.
Following is an example xfer.cmd file
-- BCPXFER.BAT
REM Parms %1=SourceServer %2=TargetServer %3=DatabaseName %4=TableName
%5=LogPath
bcp %3..%4 out \\Server\Xfer\%4.dat -c -S%1 -T -e%4-bcpout.log >> %5bcp.log
osql -S%1 -Q"truncate table %3..%4" -E >> %5bcp.log
bcp %3..%4 in \\Server\Xfer\ -c -S%2 -T -e%4-bcpout.log >> %5bcp.log
--
This makes some assumptions:
1. TRUNCATE TABLE will work on your target server, so there cannot be any
foreign key constraints for that to work. If there are FK constraints, you
will need to change to "delete table"
2. One trusted connection works on both servers. If this is not the case,
you will need to add more login information (including passwords) to the
parameter list.
3. Both servers can reach the same file share. If this is not true, then
you will need to insert a copy file step between the bcp out and the bcp in.
Etc. etc.
This is not a full solution for you, since there are many unknowns, but if
this works you then create a higher level BAT file in the form:
-- MyXfer.BAT
call bcpxfer.bat Server1 Server2 MyDatabase MyTable1 MyLogPath
call bcpxfer.bat Server1 Server2 MyDatabase MyTable2 MyLogPath
call bcpxfer.bat Server1 Server2 MyDatabase MyTable3 MyLogPath
RLF
PS - Are you the same person as Andrea Anastasescu?
"andrea" <a@.a.a> wrote in message
news:ex%23SKyB5HHA.464@.TK2MSFTNGP02.phx.gbl...
> Hi everybody,
> I have the following problem: I have a very large data base used by our
> clients for beta-testing. With prohibitions of just taking the data (using
> a backup or so)
> I can connect to this machine by accesing two terminal service - poor
> network performance so on.
> I have to take data out of this database - to have a proper "seed" for our
> load test scenarios.
> I tried bulk copy - well, I still have some problems with the inserts in
> our database, but I am wondering wether is there a better way of
> automating the task of exporting every table to a file using bcp - here
> comes the problem wether I need a format file for every table)
> Maybe I can achieve the same result in a more elegent way with DTS
> packages? Is there a way to do this disconnected import export operation
> using dts and some intermediery text/binary files that I can move between
> the machines?
> Any help is welcomed,
> Andre
>
Disconnected Edit in SSIS 2005
Is there a match for SQL Server 2000 DTS Package "Disconnected Edit" in SQL
Server 2005 Integration Services ? If so, What ?
Thanks.In SSIS you can accomplish editing packages without a connection to the SQL
Server Several different ways.
If you are using file system deployment you can just make sure that your
development folder for the dtsx files is something different then the folder
that the agent is executing packages from.
If you are using SQL Server deployment then every package that you are
working is essentially disconnected. You have to deploy it to the sql
server using the deploy option inside of the business intelligence studio or
a package installer.
In both cases, you do not need any type of connection to the SQL server
until you deploy. You will lose some niceties that way since you cant
connect to get column or table info.
Make sense?
/*
Warren Brunk - MCITP - SQL 2005, MCDBA
www.techintsolutions.com
Tech Blog - www.technologyis.com
*/
"DXC" <DXC@.discussions.microsoft.com> wrote in message
news:32FB5B16-0012-4DD8-98CF-E52CF07BB77C@.microsoft.com...
> Is there a match for SQL Server 2000 DTS Package "Disconnected Edit" in
> SQL
> Server 2005 Integration Services ? If so, What ?
> Thanks.|||No it doesn't. Here is why,
I imported a DTS package from a SQL Server 2000 server to 2005 Integration
services on another SQL Server 2005 computer. Regardles of where I open it,
it takes at least 20 second to scroll the horizantal bar 1 inch. I am
assuming that it is trying to check the resources/connections even though
they don't exists on the new server. This is why I thought that disconnected
edit may help to speed editing the DTS package or the SSIS package since it
has been converted..........
Thanks.
"Warren Brunk" wrote:
> In SSIS you can accomplish editing packages without a connection to the SQL
> Server Several different ways.
> If you are using file system deployment you can just make sure that your
> development folder for the dtsx files is something different then the folder
> that the agent is executing packages from.
> If you are using SQL Server deployment then every package that you are
> working is essentially disconnected. You have to deploy it to the sql
> server using the deploy option inside of the business intelligence studio or
> a package installer.
> In both cases, you do not need any type of connection to the SQL server
> until you deploy. You will lose some niceties that way since you cant
> connect to get column or table info.
> Make sense?
>
> --
> /*
> Warren Brunk - MCITP - SQL 2005, MCDBA
> www.techintsolutions.com
> Tech Blog - www.technologyis.com
> */
>
> "DXC" <DXC@.discussions.microsoft.com> wrote in message
> news:32FB5B16-0012-4DD8-98CF-E52CF07BB77C@.microsoft.com...
> > Is there a match for SQL Server 2000 DTS Package "Disconnected Edit" in
> > SQL
> > Server 2005 Integration Services ? If so, What ?
> >
> > Thanks.
>
>
Server 2005 Integration Services ? If so, What ?
Thanks.In SSIS you can accomplish editing packages without a connection to the SQL
Server Several different ways.
If you are using file system deployment you can just make sure that your
development folder for the dtsx files is something different then the folder
that the agent is executing packages from.
If you are using SQL Server deployment then every package that you are
working is essentially disconnected. You have to deploy it to the sql
server using the deploy option inside of the business intelligence studio or
a package installer.
In both cases, you do not need any type of connection to the SQL server
until you deploy. You will lose some niceties that way since you cant
connect to get column or table info.
Make sense?
/*
Warren Brunk - MCITP - SQL 2005, MCDBA
www.techintsolutions.com
Tech Blog - www.technologyis.com
*/
"DXC" <DXC@.discussions.microsoft.com> wrote in message
news:32FB5B16-0012-4DD8-98CF-E52CF07BB77C@.microsoft.com...
> Is there a match for SQL Server 2000 DTS Package "Disconnected Edit" in
> SQL
> Server 2005 Integration Services ? If so, What ?
> Thanks.|||No it doesn't. Here is why,
I imported a DTS package from a SQL Server 2000 server to 2005 Integration
services on another SQL Server 2005 computer. Regardles of where I open it,
it takes at least 20 second to scroll the horizantal bar 1 inch. I am
assuming that it is trying to check the resources/connections even though
they don't exists on the new server. This is why I thought that disconnected
edit may help to speed editing the DTS package or the SSIS package since it
has been converted..........
Thanks.
"Warren Brunk" wrote:
> In SSIS you can accomplish editing packages without a connection to the SQL
> Server Several different ways.
> If you are using file system deployment you can just make sure that your
> development folder for the dtsx files is something different then the folder
> that the agent is executing packages from.
> If you are using SQL Server deployment then every package that you are
> working is essentially disconnected. You have to deploy it to the sql
> server using the deploy option inside of the business intelligence studio or
> a package installer.
> In both cases, you do not need any type of connection to the SQL server
> until you deploy. You will lose some niceties that way since you cant
> connect to get column or table info.
> Make sense?
>
> --
> /*
> Warren Brunk - MCITP - SQL 2005, MCDBA
> www.techintsolutions.com
> Tech Blog - www.technologyis.com
> */
>
> "DXC" <DXC@.discussions.microsoft.com> wrote in message
> news:32FB5B16-0012-4DD8-98CF-E52CF07BB77C@.microsoft.com...
> > Is there a match for SQL Server 2000 DTS Package "Disconnected Edit" in
> > SQL
> > Server 2005 Integration Services ? If so, What ?
> >
> > Thanks.
>
>
Disconnected Edit in SSIS 2005
Is there a match for SQL Server 2000 DTS Package "Disconnected Edit" in SQL
Server 2005 Integration Services ? If so, What ?
Thanks.In SSIS you can accomplish editing packages without a connection to the SQL
Server Several different ways.
If you are using file system deployment you can just make sure that your
development folder for the dtsx files is something different then the folder
that the agent is executing packages from.
If you are using SQL Server deployment then every package that you are
working is essentially disconnected. You have to deploy it to the sql
server using the deploy option inside of the business intelligence studio or
a package installer.
In both cases, you do not need any type of connection to the SQL server
until you deploy. You will lose some niceties that way since you cant
connect to get column or table info.
Make sense?
/*
Warren Brunk - MCITP - SQL 2005, MCDBA
www.techintsolutions.com
Tech Blog - www.technologyis.com
*/
"DXC" <DXC@.discussions.microsoft.com> wrote in message
news:32FB5B16-0012-4DD8-98CF-E52CF07BB77C@.microsoft.com...
> Is there a match for SQL Server 2000 DTS Package "Disconnected Edit" in
> SQL
> Server 2005 Integration Services ? If so, What ?
> Thanks.|||No it doesn't. Here is why,
I imported a DTS package from a SQL Server 2000 server to 2005 Integration
services on another SQL Server 2005 computer. Regardles of where I open it,
it takes at least 20 second to scroll the horizantal bar 1 inch. I am
assuming that it is trying to check the resources/connections even though
they don't exists on the new server. This is why I thought that disconnected
edit may help to speed editing the DTS package or the SSIS package since it
has been converted..........
Thanks.
"Warren Brunk" wrote:
> In SSIS you can accomplish editing packages without a connection to the SQ
L
> Server Several different ways.
> If you are using file system deployment you can just make sure that your
> development folder for the dtsx files is something different then the fold
er
> that the agent is executing packages from.
> If you are using SQL Server deployment then every package that you are
> working is essentially disconnected. You have to deploy it to the sql
> server using the deploy option inside of the business intelligence studio
or
> a package installer.
> In both cases, you do not need any type of connection to the SQL server
> until you deploy. You will lose some niceties that way since you cant
> connect to get column or table info.
> Make sense?
>
> --
> /*
> Warren Brunk - MCITP - SQL 2005, MCDBA
> www.techintsolutions.com
> Tech Blog - www.technologyis.com
> */
>
> "DXC" <DXC@.discussions.microsoft.com> wrote in message
> news:32FB5B16-0012-4DD8-98CF-E52CF07BB77C@.microsoft.com...
>
>
Server 2005 Integration Services ? If so, What ?
Thanks.In SSIS you can accomplish editing packages without a connection to the SQL
Server Several different ways.
If you are using file system deployment you can just make sure that your
development folder for the dtsx files is something different then the folder
that the agent is executing packages from.
If you are using SQL Server deployment then every package that you are
working is essentially disconnected. You have to deploy it to the sql
server using the deploy option inside of the business intelligence studio or
a package installer.
In both cases, you do not need any type of connection to the SQL server
until you deploy. You will lose some niceties that way since you cant
connect to get column or table info.
Make sense?
/*
Warren Brunk - MCITP - SQL 2005, MCDBA
www.techintsolutions.com
Tech Blog - www.technologyis.com
*/
"DXC" <DXC@.discussions.microsoft.com> wrote in message
news:32FB5B16-0012-4DD8-98CF-E52CF07BB77C@.microsoft.com...
> Is there a match for SQL Server 2000 DTS Package "Disconnected Edit" in
> SQL
> Server 2005 Integration Services ? If so, What ?
> Thanks.|||No it doesn't. Here is why,
I imported a DTS package from a SQL Server 2000 server to 2005 Integration
services on another SQL Server 2005 computer. Regardles of where I open it,
it takes at least 20 second to scroll the horizantal bar 1 inch. I am
assuming that it is trying to check the resources/connections even though
they don't exists on the new server. This is why I thought that disconnected
edit may help to speed editing the DTS package or the SSIS package since it
has been converted..........
Thanks.
"Warren Brunk" wrote:
> In SSIS you can accomplish editing packages without a connection to the SQ
L
> Server Several different ways.
> If you are using file system deployment you can just make sure that your
> development folder for the dtsx files is something different then the fold
er
> that the agent is executing packages from.
> If you are using SQL Server deployment then every package that you are
> working is essentially disconnected. You have to deploy it to the sql
> server using the deploy option inside of the business intelligence studio
or
> a package installer.
> In both cases, you do not need any type of connection to the SQL server
> until you deploy. You will lose some niceties that way since you cant
> connect to get column or table info.
> Make sense?
>
> --
> /*
> Warren Brunk - MCITP - SQL 2005, MCDBA
> www.techintsolutions.com
> Tech Blog - www.technologyis.com
> */
>
> "DXC" <DXC@.discussions.microsoft.com> wrote in message
> news:32FB5B16-0012-4DD8-98CF-E52CF07BB77C@.microsoft.com...
>
>
Disconnected Edit in SSIS 2005
Is there a match for SQL Server 2000 DTS Package "Disconnected Edit" in SQL
Server 2005 Integration Services ? If so, What ?
Thanks.
In SSIS you can accomplish editing packages without a connection to the SQL
Server Several different ways.
If you are using file system deployment you can just make sure that your
development folder for the dtsx files is something different then the folder
that the agent is executing packages from.
If you are using SQL Server deployment then every package that you are
working is essentially disconnected. You have to deploy it to the sql
server using the deploy option inside of the business intelligence studio or
a package installer.
In both cases, you do not need any type of connection to the SQL server
until you deploy. You will lose some niceties that way since you cant
connect to get column or table info.
Make sense?
/*
Warren Brunk - MCITP - SQL 2005, MCDBA
www.techintsolutions.com
Tech Blog - www.technologyis.com
*/
"DXC" <DXC@.discussions.microsoft.com> wrote in message
news:32FB5B16-0012-4DD8-98CF-E52CF07BB77C@.microsoft.com...
> Is there a match for SQL Server 2000 DTS Package "Disconnected Edit" in
> SQL
> Server 2005 Integration Services ? If so, What ?
> Thanks.
|||No it doesn't. Here is why,
I imported a DTS package from a SQL Server 2000 server to 2005 Integration
services on another SQL Server 2005 computer. Regardles of where I open it,
it takes at least 20 second to scroll the horizantal bar 1 inch. I am
assuming that it is trying to check the resources/connections even though
they don't exists on the new server. This is why I thought that disconnected
edit may help to speed editing the DTS package or the SSIS package since it
has been converted..........
Thanks.
"Warren Brunk" wrote:
> In SSIS you can accomplish editing packages without a connection to the SQL
> Server Several different ways.
> If you are using file system deployment you can just make sure that your
> development folder for the dtsx files is something different then the folder
> that the agent is executing packages from.
> If you are using SQL Server deployment then every package that you are
> working is essentially disconnected. You have to deploy it to the sql
> server using the deploy option inside of the business intelligence studio or
> a package installer.
> In both cases, you do not need any type of connection to the SQL server
> until you deploy. You will lose some niceties that way since you cant
> connect to get column or table info.
> Make sense?
>
> --
> /*
> Warren Brunk - MCITP - SQL 2005, MCDBA
> www.techintsolutions.com
> Tech Blog - www.technologyis.com
> */
>
> "DXC" <DXC@.discussions.microsoft.com> wrote in message
> news:32FB5B16-0012-4DD8-98CF-E52CF07BB77C@.microsoft.com...
>
>
sql
Server 2005 Integration Services ? If so, What ?
Thanks.
In SSIS you can accomplish editing packages without a connection to the SQL
Server Several different ways.
If you are using file system deployment you can just make sure that your
development folder for the dtsx files is something different then the folder
that the agent is executing packages from.
If you are using SQL Server deployment then every package that you are
working is essentially disconnected. You have to deploy it to the sql
server using the deploy option inside of the business intelligence studio or
a package installer.
In both cases, you do not need any type of connection to the SQL server
until you deploy. You will lose some niceties that way since you cant
connect to get column or table info.
Make sense?
/*
Warren Brunk - MCITP - SQL 2005, MCDBA
www.techintsolutions.com
Tech Blog - www.technologyis.com
*/
"DXC" <DXC@.discussions.microsoft.com> wrote in message
news:32FB5B16-0012-4DD8-98CF-E52CF07BB77C@.microsoft.com...
> Is there a match for SQL Server 2000 DTS Package "Disconnected Edit" in
> SQL
> Server 2005 Integration Services ? If so, What ?
> Thanks.
|||No it doesn't. Here is why,
I imported a DTS package from a SQL Server 2000 server to 2005 Integration
services on another SQL Server 2005 computer. Regardles of where I open it,
it takes at least 20 second to scroll the horizantal bar 1 inch. I am
assuming that it is trying to check the resources/connections even though
they don't exists on the new server. This is why I thought that disconnected
edit may help to speed editing the DTS package or the SSIS package since it
has been converted..........
Thanks.
"Warren Brunk" wrote:
> In SSIS you can accomplish editing packages without a connection to the SQL
> Server Several different ways.
> If you are using file system deployment you can just make sure that your
> development folder for the dtsx files is something different then the folder
> that the agent is executing packages from.
> If you are using SQL Server deployment then every package that you are
> working is essentially disconnected. You have to deploy it to the sql
> server using the deploy option inside of the business intelligence studio or
> a package installer.
> In both cases, you do not need any type of connection to the SQL server
> until you deploy. You will lose some niceties that way since you cant
> connect to get column or table info.
> Make sense?
>
> --
> /*
> Warren Brunk - MCITP - SQL 2005, MCDBA
> www.techintsolutions.com
> Tech Blog - www.technologyis.com
> */
>
> "DXC" <DXC@.discussions.microsoft.com> wrote in message
> news:32FB5B16-0012-4DD8-98CF-E52CF07BB77C@.microsoft.com...
>
>
sql
Disconnected Database solution
Is Windows CE the correct choice for developing an
application which will be used on a laptop type of device
while disconnected from the main database (SQL Server
2000 Ent. Ed.) but when connection is available will
connect and synchronize with the master database (bi-
directional upload/download new information since last
sync). Are there any such features available in SQL
Server 2000 Ent. Edition where I can work with my local
instance of the database and then somehow at the SQL
Server level I can synchronize with the master database
in a relatively short period of time. Any assistance or
point in the right direction would be much appreciated.
-- Devendra.
Hi
Have a look at SQL Server CE edition on
http://www.microsoft.com/sql/ce/default.asp
You can run merge replication to sync between your device and the master
server.
Regards
Mike
"Devendra Rao" wrote:
> Is Windows CE the correct choice for developing an
> application which will be used on a laptop type of device
> while disconnected from the main database (SQL Server
> 2000 Ent. Ed.) but when connection is available will
> connect and synchronize with the master database (bi-
> directional upload/download new information since last
> sync). Are there any such features available in SQL
> Server 2000 Ent. Edition where I can work with my local
> instance of the database and then somehow at the SQL
> Server level I can synchronize with the master database
> in a relatively short period of time. Any assistance or
> point in the right direction would be much appreciated.
> -- Devendra.
>
application which will be used on a laptop type of device
while disconnected from the main database (SQL Server
2000 Ent. Ed.) but when connection is available will
connect and synchronize with the master database (bi-
directional upload/download new information since last
sync). Are there any such features available in SQL
Server 2000 Ent. Edition where I can work with my local
instance of the database and then somehow at the SQL
Server level I can synchronize with the master database
in a relatively short period of time. Any assistance or
point in the right direction would be much appreciated.
-- Devendra.
Hi
Have a look at SQL Server CE edition on
http://www.microsoft.com/sql/ce/default.asp
You can run merge replication to sync between your device and the master
server.
Regards
Mike
"Devendra Rao" wrote:
> Is Windows CE the correct choice for developing an
> application which will be used on a laptop type of device
> while disconnected from the main database (SQL Server
> 2000 Ent. Ed.) but when connection is available will
> connect and synchronize with the master database (bi-
> directional upload/download new information since last
> sync). Are there any such features available in SQL
> Server 2000 Ent. Edition where I can work with my local
> instance of the database and then somehow at the SQL
> Server level I can synchronize with the master database
> in a relatively short period of time. Any assistance or
> point in the right direction would be much appreciated.
> -- Devendra.
>
Disconnected architecture and other issues
1. If ADO .Net supports disconnected architecture why do we have to close a
connection after we open it? Isn't ADO .Net supposed to do that automaticall
y
since it supports the disconntected architecture?
2. Why is it that i don't have to open a connection (by writing e.g.
Conn.Open)
after i establish a connection visually through the Server Explorer? Does
establishing a connection through the Server Explorer automatically opens th
e
connection?
3. What are the rules regarding how many datasets you can have in one
application.
Any insights on these matters will be highly appreciated by this novice.
Many thanks for Aaron's help last time. It was very useful.> 1. If ADO .Net supports disconnected architecture why do we have to close
> a
> connection after we open it? Isn't ADO .Net supposed to do that
> automatically
> since it supports the disconntected architecture?
ADO.Net support both connected and disconnected models. The Close method
gives you more control over when the connection is released. For example,
if you need to load several datasets, you can load all using the same open
connection and then call close when you are done. This is more efficient
that opening/closing a connection for each dataset.
> 2. Why is it that i don't have to open a connection (by writing e.g.
> Conn.Open)
> after i establish a connection visually through the Server Explorer? Does
> establishing a connection through the Server Explorer automatically opens
> the
> connection?
The GUI opens a SQL Server connection just like any other SQL Server
application. You can see the activity with a Profiler trace.
> 3. What are the rules regarding how many datasets you can have in one
> application.
AFAIK, available memory.
Hope this helps.
Dan Guzman
SQL Server MVP
"Nab" <Nab@.discussions.microsoft.com> wrote in message
news:470255AF-D517-4ADF-8104-C904D0106DAD@.microsoft.com...
> 1. If ADO .Net supports disconnected architecture why do we have to close
> a
> connection after we open it? Isn't ADO .Net supposed to do that
> automatically
> since it supports the disconntected architecture?
> 2. Why is it that i don't have to open a connection (by writing e.g.
> Conn.Open)
> after i establish a connection visually through the Server Explorer? Does
> establishing a connection through the Server Explorer automatically opens
> the
> connection?
> 3. What are the rules regarding how many datasets you can have in one
> application.
> Any insights on these matters will be highly appreciated by this novice.
> Many thanks for Aaron's help last time. It was very useful.
>
>
connection after we open it? Isn't ADO .Net supposed to do that automaticall
y
since it supports the disconntected architecture?
2. Why is it that i don't have to open a connection (by writing e.g.
Conn.Open)
after i establish a connection visually through the Server Explorer? Does
establishing a connection through the Server Explorer automatically opens th
e
connection?
3. What are the rules regarding how many datasets you can have in one
application.
Any insights on these matters will be highly appreciated by this novice.
Many thanks for Aaron's help last time. It was very useful.> 1. If ADO .Net supports disconnected architecture why do we have to close
> a
> connection after we open it? Isn't ADO .Net supposed to do that
> automatically
> since it supports the disconntected architecture?
ADO.Net support both connected and disconnected models. The Close method
gives you more control over when the connection is released. For example,
if you need to load several datasets, you can load all using the same open
connection and then call close when you are done. This is more efficient
that opening/closing a connection for each dataset.
> 2. Why is it that i don't have to open a connection (by writing e.g.
> Conn.Open)
> after i establish a connection visually through the Server Explorer? Does
> establishing a connection through the Server Explorer automatically opens
> the
> connection?
The GUI opens a SQL Server connection just like any other SQL Server
application. You can see the activity with a Profiler trace.
> 3. What are the rules regarding how many datasets you can have in one
> application.
AFAIK, available memory.
Hope this helps.
Dan Guzman
SQL Server MVP
"Nab" <Nab@.discussions.microsoft.com> wrote in message
news:470255AF-D517-4ADF-8104-C904D0106DAD@.microsoft.com...
> 1. If ADO .Net supports disconnected architecture why do we have to close
> a
> connection after we open it? Isn't ADO .Net supposed to do that
> automatically
> since it supports the disconntected architecture?
> 2. Why is it that i don't have to open a connection (by writing e.g.
> Conn.Open)
> after i establish a connection visually through the Server Explorer? Does
> establishing a connection through the Server Explorer automatically opens
> the
> connection?
> 3. What are the rules regarding how many datasets you can have in one
> application.
> Any insights on these matters will be highly appreciated by this novice.
> Many thanks for Aaron's help last time. It was very useful.
>
>
2012年3月19日星期一
Disconnected application w/xml data source - how do I create strongly typed datasets?
I am sourcing my disconnected application with an xml data source but would
like to use strongly type datasets in my application using Visual Studio
2005. Is this possible?
JimOn Jul 21, 7:39 am, "Jim" <j...@.myemai.com> wrote:
> I am sourcing my disconnected application with an xml data source but woul
d
> like to use strongly type datasets in my application using Visual Studio
> 2005. Is this possible?
> Jim
VS comes with xsd.exe. You pass your xml to the tool and it will
create strongly typed dataset class for you.
Mike
like to use strongly type datasets in my application using Visual Studio
2005. Is this possible?
JimOn Jul 21, 7:39 am, "Jim" <j...@.myemai.com> wrote:
> I am sourcing my disconnected application with an xml data source but woul
d
> like to use strongly type datasets in my application using Visual Studio
> 2005. Is this possible?
> Jim
VS comes with xsd.exe. You pass your xml to the tool and it will
create strongly typed dataset class for you.
Mike
Disconnected application w/xml data source - how do I create strongly typed datasets?
I am sourcing my disconnected application with an xml data source but would
like to use strongly type datasets in my application using Visual Studio
2005. Is this possible?
Jim
On Jul 21, 7:39 am, "Jim" <j...@.myemai.com> wrote:
> I am sourcing my disconnected application with an xml data source but would
> like to use strongly type datasets in my application using Visual Studio
> 2005. Is this possible?
> Jim
VS comes with xsd.exe. You pass your xml to the tool and it will
create strongly typed dataset class for you.
Mike
like to use strongly type datasets in my application using Visual Studio
2005. Is this possible?
Jim
On Jul 21, 7:39 am, "Jim" <j...@.myemai.com> wrote:
> I am sourcing my disconnected application with an xml data source but would
> like to use strongly type datasets in my application using Visual Studio
> 2005. Is this possible?
> Jim
VS comes with xsd.exe. You pass your xml to the tool and it will
create strongly typed dataset class for you.
Mike
Disconnected application and replication
Hi
We have a situation where the sql server backend is on the server but
several laptop users need to disconnect and still be able to use the data.
Can we have copies of say sql express on each laptop which can replicate
data with the sql server when connected and still make the data available
while disconnected from the server? Will this work, specially when the app
front end will be in vb.net?
Thanks
RegardsJohn,
yes - this can work. You'd have a merge publication and pull subscriptions,
activated by your vb.net application.
Cheers,
Paul Ibison SQL Server MVP, www.replicationanswers.com
(recommended sql server 2000 replication book:
http://www.nwsu.com/0974973602p.html)|||Or you could have the sync managed by Windows Synchronization Manager or
task scheduler. SQL Server Express does not ship with a scheduler. I would
also have a look at SQL Server Everywhere edition - due out this summer.
Hilary Cotter
Director of Text Mining and Database Strategy
RelevantNOISE.Com - Dedicated to mining blogs for business intelligence.
This posting is my own and doesn't necessarily represent RelevantNoise's
positions, strategies or opinions.
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
"Paul Ibison" <Paul.Ibison@.Pygmalion.Com> wrote in message
news:umptsNFZGHA.4144@.TK2MSFTNGP04.phx.gbl...
> John,
> yes - this can work. You'd have a merge publication and pull
> subscriptions, activated by your vb.net application.
> Cheers,
> Paul Ibison SQL Server MVP, www.replicationanswers.com
> (recommended sql server 2000 replication book:
> http://www.nwsu.com/0974973602p.html)
>|||Ok, but is it the best/recommended way? I mean what do other people do in
this situation?
Thanks
Regards
"Paul Ibison" <Paul.Ibison@.Pygmalion.Com> wrote in message
news:umptsNFZGHA.4144@.TK2MSFTNGP04.phx.gbl...
> John,
> yes - this can work. You'd have a merge publication and pull
> subscriptions, activated by your vb.net application.
> Cheers,
> Paul Ibison SQL Server MVP, www.replicationanswers.com
> (recommended sql server 2000 replication book:
> http://www.nwsu.com/0974973602p.html)
>|||It depends on your requirements. The question is do you want the app to
manage the sync, or do you want it done externally.
If you want the app to manage the sync use the activeX merge control. If you
do not use WSM or task scheduler. WSM has a rich set of functionality for
controlling the sync. If you choose to use task scheduler you will have to
have it instantiate the activeX control to do the sync.
Hilary Cotter
Director of Text Mining and Database Strategy
RelevantNOISE.Com - Dedicated to mining blogs for business intelligence.
This posting is my own and doesn't necessarily represent RelevantNoise's
positions, strategies or opinions.
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
"John" <John@.nospam.infovis.co.uk> wrote in message
news:uGU3ovHZGHA.4944@.TK2MSFTNGP02.phx.gbl...
> Ok, but is it the best/recommended way? I mean what do other people do in
> this situation?
> Thanks
> Regards
> "Paul Ibison" <Paul.Ibison@.Pygmalion.Com> wrote in message
> news:umptsNFZGHA.4144@.TK2MSFTNGP04.phx.gbl...
>
We have a situation where the sql server backend is on the server but
several laptop users need to disconnect and still be able to use the data.
Can we have copies of say sql express on each laptop which can replicate
data with the sql server when connected and still make the data available
while disconnected from the server? Will this work, specially when the app
front end will be in vb.net?
Thanks
RegardsJohn,
yes - this can work. You'd have a merge publication and pull subscriptions,
activated by your vb.net application.
Cheers,
Paul Ibison SQL Server MVP, www.replicationanswers.com
(recommended sql server 2000 replication book:
http://www.nwsu.com/0974973602p.html)|||Or you could have the sync managed by Windows Synchronization Manager or
task scheduler. SQL Server Express does not ship with a scheduler. I would
also have a look at SQL Server Everywhere edition - due out this summer.
Hilary Cotter
Director of Text Mining and Database Strategy
RelevantNOISE.Com - Dedicated to mining blogs for business intelligence.
This posting is my own and doesn't necessarily represent RelevantNoise's
positions, strategies or opinions.
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
"Paul Ibison" <Paul.Ibison@.Pygmalion.Com> wrote in message
news:umptsNFZGHA.4144@.TK2MSFTNGP04.phx.gbl...
> John,
> yes - this can work. You'd have a merge publication and pull
> subscriptions, activated by your vb.net application.
> Cheers,
> Paul Ibison SQL Server MVP, www.replicationanswers.com
> (recommended sql server 2000 replication book:
> http://www.nwsu.com/0974973602p.html)
>|||Ok, but is it the best/recommended way? I mean what do other people do in
this situation?
Thanks
Regards
"Paul Ibison" <Paul.Ibison@.Pygmalion.Com> wrote in message
news:umptsNFZGHA.4144@.TK2MSFTNGP04.phx.gbl...
> John,
> yes - this can work. You'd have a merge publication and pull
> subscriptions, activated by your vb.net application.
> Cheers,
> Paul Ibison SQL Server MVP, www.replicationanswers.com
> (recommended sql server 2000 replication book:
> http://www.nwsu.com/0974973602p.html)
>|||It depends on your requirements. The question is do you want the app to
manage the sync, or do you want it done externally.
If you want the app to manage the sync use the activeX merge control. If you
do not use WSM or task scheduler. WSM has a rich set of functionality for
controlling the sync. If you choose to use task scheduler you will have to
have it instantiate the activeX control to do the sync.
Hilary Cotter
Director of Text Mining and Database Strategy
RelevantNOISE.Com - Dedicated to mining blogs for business intelligence.
This posting is my own and doesn't necessarily represent RelevantNoise's
positions, strategies or opinions.
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
"John" <John@.nospam.infovis.co.uk> wrote in message
news:uGU3ovHZGHA.4944@.TK2MSFTNGP02.phx.gbl...
> Ok, but is it the best/recommended way? I mean what do other people do in
> this situation?
> Thanks
> Regards
> "Paul Ibison" <Paul.Ibison@.Pygmalion.Com> wrote in message
> news:umptsNFZGHA.4144@.TK2MSFTNGP04.phx.gbl...
>
Disconnected application and replication
Hi
We have a situation where the sql server backend is on the server but
several laptop users need to disconnect and still be able to use the data.
Can we have copies of say sql express on each laptop which can replicate
data with the sql server when connected and still make the data available
while disconnected from the server? Will this work, specially when the app
front end will be in vb.net?
Thanks
RegardsJohn,
yes - this can work. You'd have a merge publication and pull subscriptions,
activated by your vb.net application.
Cheers,
Paul Ibison SQL Server MVP, www.replicationanswers.com
(recommended sql server 2000 replication book:
http://www.nwsu.com/0974973602p.html)|||Or you could have the sync managed by Windows Synchronization Manager or
task scheduler. SQL Server Express does not ship with a scheduler. I would
also have a look at SQL Server Everywhere edition - due out this summer.
--
Hilary Cotter
Director of Text Mining and Database Strategy
RelevantNOISE.Com - Dedicated to mining blogs for business intelligence.
This posting is my own and doesn't necessarily represent RelevantNoise's
positions, strategies or opinions.
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
"Paul Ibison" <Paul.Ibison@.Pygmalion.Com> wrote in message
news:umptsNFZGHA.4144@.TK2MSFTNGP04.phx.gbl...
> John,
> yes - this can work. You'd have a merge publication and pull
> subscriptions, activated by your vb.net application.
> Cheers,
> Paul Ibison SQL Server MVP, www.replicationanswers.com
> (recommended sql server 2000 replication book:
> http://www.nwsu.com/0974973602p.html)
>|||Ok, but is it the best/recommended way? I mean what do other people do in
this situation?
Thanks
Regards
"Paul Ibison" <Paul.Ibison@.Pygmalion.Com> wrote in message
news:umptsNFZGHA.4144@.TK2MSFTNGP04.phx.gbl...
> John,
> yes - this can work. You'd have a merge publication and pull
> subscriptions, activated by your vb.net application.
> Cheers,
> Paul Ibison SQL Server MVP, www.replicationanswers.com
> (recommended sql server 2000 replication book:
> http://www.nwsu.com/0974973602p.html)
>|||It depends on your requirements. The question is do you want the app to
manage the sync, or do you want it done externally.
If you want the app to manage the sync use the activeX merge control. If you
do not use WSM or task scheduler. WSM has a rich set of functionality for
controlling the sync. If you choose to use task scheduler you will have to
have it instantiate the activeX control to do the sync.
--
Hilary Cotter
Director of Text Mining and Database Strategy
RelevantNOISE.Com - Dedicated to mining blogs for business intelligence.
This posting is my own and doesn't necessarily represent RelevantNoise's
positions, strategies or opinions.
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
"John" <John@.nospam.infovis.co.uk> wrote in message
news:uGU3ovHZGHA.4944@.TK2MSFTNGP02.phx.gbl...
> Ok, but is it the best/recommended way? I mean what do other people do in
> this situation?
> Thanks
> Regards
> "Paul Ibison" <Paul.Ibison@.Pygmalion.Com> wrote in message
> news:umptsNFZGHA.4144@.TK2MSFTNGP04.phx.gbl...
>> John,
>> yes - this can work. You'd have a merge publication and pull
>> subscriptions, activated by your vb.net application.
>> Cheers,
>> Paul Ibison SQL Server MVP, www.replicationanswers.com
>> (recommended sql server 2000 replication book:
>> http://www.nwsu.com/0974973602p.html)
>
We have a situation where the sql server backend is on the server but
several laptop users need to disconnect and still be able to use the data.
Can we have copies of say sql express on each laptop which can replicate
data with the sql server when connected and still make the data available
while disconnected from the server? Will this work, specially when the app
front end will be in vb.net?
Thanks
RegardsJohn,
yes - this can work. You'd have a merge publication and pull subscriptions,
activated by your vb.net application.
Cheers,
Paul Ibison SQL Server MVP, www.replicationanswers.com
(recommended sql server 2000 replication book:
http://www.nwsu.com/0974973602p.html)|||Or you could have the sync managed by Windows Synchronization Manager or
task scheduler. SQL Server Express does not ship with a scheduler. I would
also have a look at SQL Server Everywhere edition - due out this summer.
--
Hilary Cotter
Director of Text Mining and Database Strategy
RelevantNOISE.Com - Dedicated to mining blogs for business intelligence.
This posting is my own and doesn't necessarily represent RelevantNoise's
positions, strategies or opinions.
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
"Paul Ibison" <Paul.Ibison@.Pygmalion.Com> wrote in message
news:umptsNFZGHA.4144@.TK2MSFTNGP04.phx.gbl...
> John,
> yes - this can work. You'd have a merge publication and pull
> subscriptions, activated by your vb.net application.
> Cheers,
> Paul Ibison SQL Server MVP, www.replicationanswers.com
> (recommended sql server 2000 replication book:
> http://www.nwsu.com/0974973602p.html)
>|||Ok, but is it the best/recommended way? I mean what do other people do in
this situation?
Thanks
Regards
"Paul Ibison" <Paul.Ibison@.Pygmalion.Com> wrote in message
news:umptsNFZGHA.4144@.TK2MSFTNGP04.phx.gbl...
> John,
> yes - this can work. You'd have a merge publication and pull
> subscriptions, activated by your vb.net application.
> Cheers,
> Paul Ibison SQL Server MVP, www.replicationanswers.com
> (recommended sql server 2000 replication book:
> http://www.nwsu.com/0974973602p.html)
>|||It depends on your requirements. The question is do you want the app to
manage the sync, or do you want it done externally.
If you want the app to manage the sync use the activeX merge control. If you
do not use WSM or task scheduler. WSM has a rich set of functionality for
controlling the sync. If you choose to use task scheduler you will have to
have it instantiate the activeX control to do the sync.
--
Hilary Cotter
Director of Text Mining and Database Strategy
RelevantNOISE.Com - Dedicated to mining blogs for business intelligence.
This posting is my own and doesn't necessarily represent RelevantNoise's
positions, strategies or opinions.
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
"John" <John@.nospam.infovis.co.uk> wrote in message
news:uGU3ovHZGHA.4944@.TK2MSFTNGP02.phx.gbl...
> Ok, but is it the best/recommended way? I mean what do other people do in
> this situation?
> Thanks
> Regards
> "Paul Ibison" <Paul.Ibison@.Pygmalion.Com> wrote in message
> news:umptsNFZGHA.4144@.TK2MSFTNGP04.phx.gbl...
>> John,
>> yes - this can work. You'd have a merge publication and pull
>> subscriptions, activated by your vb.net application.
>> Cheers,
>> Paul Ibison SQL Server MVP, www.replicationanswers.com
>> (recommended sql server 2000 replication book:
>> http://www.nwsu.com/0974973602p.html)
>
Disconnected app with sql server compact
Hi
I am developing an app in vb.net 2008 with sql server 2000 backend. I also
need disconnected version of the app for laptop users who would connect off
and on with LAN and thereby with the company sql server 2000. I am wondering
if I can use sql server compact 3.5 for local caching when laptops are
disconnected. My question is; how would my app use views and stored
procedures in disconnected mode as sql server compact does not support
either of these. Any help to clarify this would be appreciated.
Thanks
Regards
The local Compact Edition database could be used for data caching. You could
write your own managed code to access it but as you found, there is no
support for SPs or Views. Your only other alternative would be to use the
Express edition on the client system which does support SPs and Views. In
either case you would want to use one of the various synchronization
paradigms to keep the two databases in sync.
____________________________________
William (Bill) Vaughn
Author, Mentor, Consultant, Dad, Grandpa
Microsoft MVP
INETA Speaker
www.betav.com
www.betav.com/blog/billva
Please reply only to the newsgroup so that others can benefit.
This posting is provided "AS IS" with no warranties, and confers no rights.
__________________________________
Visit www.hitchhikerguides.net to get more information on my latest book:
Hitchhiker's Guide to Visual Studio and SQL Server (7th Edition)
and Hitchhiker's Guide to SQL Server 2005 Compact Edition (EBook)
------
"John" <John@.nospam.infovis.co.uk> wrote in message
news:O5clkypMIHA.4480@.TK2MSFTNGP06.phx.gbl...
> Hi
> I am developing an app in vb.net 2008 with sql server 2000 backend. I also
> need disconnected version of the app for laptop users who would connect
> off and on with LAN and thereby with the company sql server 2000. I am
> wondering if I can use sql server compact 3.5 for local caching when
> laptops are disconnected. My question is; how would my app use views and
> stored procedures in disconnected mode as sql server compact does not
> support either of these. Any help to clarify this would be appreciated.
> Thanks
> Regards
>
|||Like Bill V said, the main point is that you'd need to synchronize your
data. since there aren't views or stored procs, there's no way to do it
directly. You can create a backgroun thread or other mechanism to determine
when you are connected to the network, and when you are, flip a flag and
then use your DALC to talk directly to the big sql server.
You can mimick views (although not anything close to the real thing) by
filling a datatable with a query that corresponds to what the view was.
Although I'm not going to even touch the stored proc vs dynamic sql debate,
I can say that much of the benefit of using stored procs diminishes when
you're using a local db like Compact Edition in this manner.
You can also just bypass CE altogether. Pull down the data from sql server
into a dataset that contains everything you need to work with, interact with
that local data, buy some persistence by saving it to XML using writexml and
then when you're connected again, you can just run your Update() on the full
sql server. There's a ton of tradeoffs here so don't take this is a
recommendation, rather it's just a statement saying if you only need a
local cache of data, you don't necessarily need Compact Edition at all.
If it were mine though, i'd do as Mr Vaughn says and use it w/
synchronization.
"John" <John@.nospam.infovis.co.uk> wrote in message
news:O5clkypMIHA.4480@.TK2MSFTNGP06.phx.gbl...
> Hi
> I am developing an app in vb.net 2008 with sql server 2000 backend. I also
> need disconnected version of the app for laptop users who would connect
> off and on with LAN and thereby with the company sql server 2000. I am
> wondering if I can use sql server compact 3.5 for local caching when
> laptops are disconnected. My question is; how would my app use views and
> stored procedures in disconnected mode as sql server compact does not
> support either of these. Any help to clarify this would be appreciated.
> Thanks
> Regards
>
I am developing an app in vb.net 2008 with sql server 2000 backend. I also
need disconnected version of the app for laptop users who would connect off
and on with LAN and thereby with the company sql server 2000. I am wondering
if I can use sql server compact 3.5 for local caching when laptops are
disconnected. My question is; how would my app use views and stored
procedures in disconnected mode as sql server compact does not support
either of these. Any help to clarify this would be appreciated.
Thanks
Regards
The local Compact Edition database could be used for data caching. You could
write your own managed code to access it but as you found, there is no
support for SPs or Views. Your only other alternative would be to use the
Express edition on the client system which does support SPs and Views. In
either case you would want to use one of the various synchronization
paradigms to keep the two databases in sync.
____________________________________
William (Bill) Vaughn
Author, Mentor, Consultant, Dad, Grandpa
Microsoft MVP
INETA Speaker
www.betav.com
www.betav.com/blog/billva
Please reply only to the newsgroup so that others can benefit.
This posting is provided "AS IS" with no warranties, and confers no rights.
__________________________________
Visit www.hitchhikerguides.net to get more information on my latest book:
Hitchhiker's Guide to Visual Studio and SQL Server (7th Edition)
and Hitchhiker's Guide to SQL Server 2005 Compact Edition (EBook)
------
"John" <John@.nospam.infovis.co.uk> wrote in message
news:O5clkypMIHA.4480@.TK2MSFTNGP06.phx.gbl...
> Hi
> I am developing an app in vb.net 2008 with sql server 2000 backend. I also
> need disconnected version of the app for laptop users who would connect
> off and on with LAN and thereby with the company sql server 2000. I am
> wondering if I can use sql server compact 3.5 for local caching when
> laptops are disconnected. My question is; how would my app use views and
> stored procedures in disconnected mode as sql server compact does not
> support either of these. Any help to clarify this would be appreciated.
> Thanks
> Regards
>
|||Like Bill V said, the main point is that you'd need to synchronize your
data. since there aren't views or stored procs, there's no way to do it
directly. You can create a backgroun thread or other mechanism to determine
when you are connected to the network, and when you are, flip a flag and
then use your DALC to talk directly to the big sql server.
You can mimick views (although not anything close to the real thing) by
filling a datatable with a query that corresponds to what the view was.
Although I'm not going to even touch the stored proc vs dynamic sql debate,
I can say that much of the benefit of using stored procs diminishes when
you're using a local db like Compact Edition in this manner.
You can also just bypass CE altogether. Pull down the data from sql server
into a dataset that contains everything you need to work with, interact with
that local data, buy some persistence by saving it to XML using writexml and
then when you're connected again, you can just run your Update() on the full
sql server. There's a ton of tradeoffs here so don't take this is a
recommendation, rather it's just a statement saying if you only need a
local cache of data, you don't necessarily need Compact Edition at all.
If it were mine though, i'd do as Mr Vaughn says and use it w/
synchronization.
"John" <John@.nospam.infovis.co.uk> wrote in message
news:O5clkypMIHA.4480@.TK2MSFTNGP06.phx.gbl...
> Hi
> I am developing an app in vb.net 2008 with sql server 2000 backend. I also
> need disconnected version of the app for laptop users who would connect
> off and on with LAN and thereby with the company sql server 2000. I am
> wondering if I can use sql server compact 3.5 for local caching when
> laptops are disconnected. My question is; how would my app use views and
> stored procedures in disconnected mode as sql server compact does not
> support either of these. Any help to clarify this would be appreciated.
> Thanks
> Regards
>
Disconnected app with sql server compact
Hi
I am developing an app in vb.net 2008 with sql server 2000 backend. I also
need disconnected version of the app for laptop users who would connect off
and on with LAN and thereby with the company sql server 2000. I am wondering
if I can use sql server compact 3.5 for local caching when laptops are
disconnected. My question is; how would my app use views and stored
procedures in disconnected mode as sql server compact does not support
either of these. Any help to clarify this would be appreciated.
Thanks
Regards
If you want to use views and stored procedures, then SQL Server Compact is
not an option. However, you can use SQL Server Express, which supports
procedural T-SQL.
HTH,
Plamen Ratchev
http://www.SQLStudio.com
|||The local Compact Edition database could be used for data caching. You could
write your own managed code to access it but as you found, there is no
support for SPs or Views. Your only other alternative would be to use the
Express edition on the client system which does support SPs and Views. In
either case you would want to use one of the various synchronization
paradigms to keep the two databases in sync.
____________________________________
William (Bill) Vaughn
Author, Mentor, Consultant, Dad, Grandpa
Microsoft MVP
INETA Speaker
www.betav.com
www.betav.com/blog/billva
Please reply only to the newsgroup so that others can benefit.
This posting is provided "AS IS" with no warranties, and confers no rights.
__________________________________
Visit www.hitchhikerguides.net to get more information on my latest book:
Hitchhiker's Guide to Visual Studio and SQL Server (7th Edition)
and Hitchhiker's Guide to SQL Server 2005 Compact Edition (EBook)
------
"John" <John@.nospam.infovis.co.uk> wrote in message
news:O5clkypMIHA.4480@.TK2MSFTNGP06.phx.gbl...
> Hi
> I am developing an app in vb.net 2008 with sql server 2000 backend. I also
> need disconnected version of the app for laptop users who would connect
> off and on with LAN and thereby with the company sql server 2000. I am
> wondering if I can use sql server compact 3.5 for local caching when
> laptops are disconnected. My question is; how would my app use views and
> stored procedures in disconnected mode as sql server compact does not
> support either of these. Any help to clarify this would be appreciated.
> Thanks
> Regards
>
|||Like Bill V said, the main point is that you'd need to synchronize your
data. since there aren't views or stored procs, there's no way to do it
directly. You can create a backgroun thread or other mechanism to determine
when you are connected to the network, and when you are, flip a flag and
then use your DALC to talk directly to the big sql server.
You can mimick views (although not anything close to the real thing) by
filling a datatable with a query that corresponds to what the view was.
Although I'm not going to even touch the stored proc vs dynamic sql debate,
I can say that much of the benefit of using stored procs diminishes when
you're using a local db like Compact Edition in this manner.
You can also just bypass CE altogether. Pull down the data from sql server
into a dataset that contains everything you need to work with, interact with
that local data, buy some persistence by saving it to XML using writexml and
then when you're connected again, you can just run your Update() on the full
sql server. There's a ton of tradeoffs here so don't take this is a
recommendation, rather it's just a statement saying if you only need a
local cache of data, you don't necessarily need Compact Edition at all.
If it were mine though, i'd do as Mr Vaughn says and use it w/
synchronization.
"John" <John@.nospam.infovis.co.uk> wrote in message
news:O5clkypMIHA.4480@.TK2MSFTNGP06.phx.gbl...
> Hi
> I am developing an app in vb.net 2008 with sql server 2000 backend. I also
> need disconnected version of the app for laptop users who would connect
> off and on with LAN and thereby with the company sql server 2000. I am
> wondering if I can use sql server compact 3.5 for local caching when
> laptops are disconnected. My question is; how would my app use views and
> stored procedures in disconnected mode as sql server compact does not
> support either of these. Any help to clarify this would be appreciated.
> Thanks
> Regards
>
I am developing an app in vb.net 2008 with sql server 2000 backend. I also
need disconnected version of the app for laptop users who would connect off
and on with LAN and thereby with the company sql server 2000. I am wondering
if I can use sql server compact 3.5 for local caching when laptops are
disconnected. My question is; how would my app use views and stored
procedures in disconnected mode as sql server compact does not support
either of these. Any help to clarify this would be appreciated.
Thanks
Regards
If you want to use views and stored procedures, then SQL Server Compact is
not an option. However, you can use SQL Server Express, which supports
procedural T-SQL.
HTH,
Plamen Ratchev
http://www.SQLStudio.com
|||The local Compact Edition database could be used for data caching. You could
write your own managed code to access it but as you found, there is no
support for SPs or Views. Your only other alternative would be to use the
Express edition on the client system which does support SPs and Views. In
either case you would want to use one of the various synchronization
paradigms to keep the two databases in sync.
____________________________________
William (Bill) Vaughn
Author, Mentor, Consultant, Dad, Grandpa
Microsoft MVP
INETA Speaker
www.betav.com
www.betav.com/blog/billva
Please reply only to the newsgroup so that others can benefit.
This posting is provided "AS IS" with no warranties, and confers no rights.
__________________________________
Visit www.hitchhikerguides.net to get more information on my latest book:
Hitchhiker's Guide to Visual Studio and SQL Server (7th Edition)
and Hitchhiker's Guide to SQL Server 2005 Compact Edition (EBook)
------
"John" <John@.nospam.infovis.co.uk> wrote in message
news:O5clkypMIHA.4480@.TK2MSFTNGP06.phx.gbl...
> Hi
> I am developing an app in vb.net 2008 with sql server 2000 backend. I also
> need disconnected version of the app for laptop users who would connect
> off and on with LAN and thereby with the company sql server 2000. I am
> wondering if I can use sql server compact 3.5 for local caching when
> laptops are disconnected. My question is; how would my app use views and
> stored procedures in disconnected mode as sql server compact does not
> support either of these. Any help to clarify this would be appreciated.
> Thanks
> Regards
>
|||Like Bill V said, the main point is that you'd need to synchronize your
data. since there aren't views or stored procs, there's no way to do it
directly. You can create a backgroun thread or other mechanism to determine
when you are connected to the network, and when you are, flip a flag and
then use your DALC to talk directly to the big sql server.
You can mimick views (although not anything close to the real thing) by
filling a datatable with a query that corresponds to what the view was.
Although I'm not going to even touch the stored proc vs dynamic sql debate,
I can say that much of the benefit of using stored procs diminishes when
you're using a local db like Compact Edition in this manner.
You can also just bypass CE altogether. Pull down the data from sql server
into a dataset that contains everything you need to work with, interact with
that local data, buy some persistence by saving it to XML using writexml and
then when you're connected again, you can just run your Update() on the full
sql server. There's a ton of tradeoffs here so don't take this is a
recommendation, rather it's just a statement saying if you only need a
local cache of data, you don't necessarily need Compact Edition at all.
If it were mine though, i'd do as Mr Vaughn says and use it w/
synchronization.
"John" <John@.nospam.infovis.co.uk> wrote in message
news:O5clkypMIHA.4480@.TK2MSFTNGP06.phx.gbl...
> Hi
> I am developing an app in vb.net 2008 with sql server 2000 backend. I also
> need disconnected version of the app for laptop users who would connect
> off and on with LAN and thereby with the company sql server 2000. I am
> wondering if I can use sql server compact 3.5 for local caching when
> laptops are disconnected. My question is; how would my app use views and
> stored procedures in disconnected mode as sql server compact does not
> support either of these. Any help to clarify this would be appreciated.
> Thanks
> Regards
>
Disconnected app with sql server compact
Hi
I am developing an app in vb.net 2008 with sql server 2000 backend. I also
need disconnected version of the app for laptop users who would connect off
and on with LAN and thereby with the company sql server 2000. I am wondering
if I can use sql server compact 3.5 for local caching when laptops are
disconnected. My question is; how would my app use views and stored
procedures in disconnected mode as sql server compact does not support
either of these. Any help to clarify this would be appreciated.
Thanks
RegardsIf you want to use views and stored procedures, then SQL Server Compact is
not an option. However, you can use SQL Server Express, which supports
procedural T-SQL.
HTH,
Plamen Ratchev
http://www.SQLStudio.com|||The local Compact Edition database could be used for data caching. You could
write your own managed code to access it but as you found, there is no
support for SPs or Views. Your only other alternative would be to use the
Express edition on the client system which does support SPs and Views. In
either case you would want to use one of the various synchronization
paradigms to keep the two databases in sync.
--
____________________________________
William (Bill) Vaughn
Author, Mentor, Consultant, Dad, Grandpa
Microsoft MVP
INETA Speaker
www.betav.com
www.betav.com/blog/billva
Please reply only to the newsgroup so that others can benefit.
This posting is provided "AS IS" with no warranties, and confers no rights.
__________________________________
Visit www.hitchhikerguides.net to get more information on my latest book:
Hitchhiker's Guide to Visual Studio and SQL Server (7th Edition)
and Hitchhiker's Guide to SQL Server 2005 Compact Edition (EBook)
------
"John" <John@.nospam.infovis.co.uk> wrote in message
news:O5clkypMIHA.4480@.TK2MSFTNGP06.phx.gbl...
> Hi
> I am developing an app in vb.net 2008 with sql server 2000 backend. I also
> need disconnected version of the app for laptop users who would connect
> off and on with LAN and thereby with the company sql server 2000. I am
> wondering if I can use sql server compact 3.5 for local caching when
> laptops are disconnected. My question is; how would my app use views and
> stored procedures in disconnected mode as sql server compact does not
> support either of these. Any help to clarify this would be appreciated.
> Thanks
> Regards
>|||Like Bill V said, the main point is that you'd need to synchronize your
data. since there aren't views or stored procs, there's no way to do it
directly. You can create a backgroun thread or other mechanism to determine
when you are connected to the network, and when you are, flip a flag and
then use your DALC to talk directly to the big sql server.
You can mimick views (although not anything close to the real thing) by
filling a datatable with a query that corresponds to what the view was.
Although I'm not going to even touch the stored proc vs dynamic sql debate,
I can say that much of the benefit of using stored procs diminishes when
you're using a local db like Compact Edition in this manner.
You can also just bypass CE altogether. Pull down the data from sql server
into a dataset that contains everything you need to work with, interact with
that local data, buy some persistence by saving it to XML using writexml and
then when you're connected again, you can just run your Update() on the full
sql server. There's a ton of tradeoffs here so don't take this is a
recommendation, rather it's just a statement saying if you only need a
local cache of data, you don't necessarily need Compact Edition at all.
If it were mine though, i'd do as Mr Vaughn says and use it w/
synchronization.
"John" <John@.nospam.infovis.co.uk> wrote in message
news:O5clkypMIHA.4480@.TK2MSFTNGP06.phx.gbl...
> Hi
> I am developing an app in vb.net 2008 with sql server 2000 backend. I also
> need disconnected version of the app for laptop users who would connect
> off and on with LAN and thereby with the company sql server 2000. I am
> wondering if I can use sql server compact 3.5 for local caching when
> laptops are disconnected. My question is; how would my app use views and
> stored procedures in disconnected mode as sql server compact does not
> support either of these. Any help to clarify this would be appreciated.
> Thanks
> Regards
>
I am developing an app in vb.net 2008 with sql server 2000 backend. I also
need disconnected version of the app for laptop users who would connect off
and on with LAN and thereby with the company sql server 2000. I am wondering
if I can use sql server compact 3.5 for local caching when laptops are
disconnected. My question is; how would my app use views and stored
procedures in disconnected mode as sql server compact does not support
either of these. Any help to clarify this would be appreciated.
Thanks
RegardsIf you want to use views and stored procedures, then SQL Server Compact is
not an option. However, you can use SQL Server Express, which supports
procedural T-SQL.
HTH,
Plamen Ratchev
http://www.SQLStudio.com|||The local Compact Edition database could be used for data caching. You could
write your own managed code to access it but as you found, there is no
support for SPs or Views. Your only other alternative would be to use the
Express edition on the client system which does support SPs and Views. In
either case you would want to use one of the various synchronization
paradigms to keep the two databases in sync.
--
____________________________________
William (Bill) Vaughn
Author, Mentor, Consultant, Dad, Grandpa
Microsoft MVP
INETA Speaker
www.betav.com
www.betav.com/blog/billva
Please reply only to the newsgroup so that others can benefit.
This posting is provided "AS IS" with no warranties, and confers no rights.
__________________________________
Visit www.hitchhikerguides.net to get more information on my latest book:
Hitchhiker's Guide to Visual Studio and SQL Server (7th Edition)
and Hitchhiker's Guide to SQL Server 2005 Compact Edition (EBook)
------
"John" <John@.nospam.infovis.co.uk> wrote in message
news:O5clkypMIHA.4480@.TK2MSFTNGP06.phx.gbl...
> Hi
> I am developing an app in vb.net 2008 with sql server 2000 backend. I also
> need disconnected version of the app for laptop users who would connect
> off and on with LAN and thereby with the company sql server 2000. I am
> wondering if I can use sql server compact 3.5 for local caching when
> laptops are disconnected. My question is; how would my app use views and
> stored procedures in disconnected mode as sql server compact does not
> support either of these. Any help to clarify this would be appreciated.
> Thanks
> Regards
>|||Like Bill V said, the main point is that you'd need to synchronize your
data. since there aren't views or stored procs, there's no way to do it
directly. You can create a backgroun thread or other mechanism to determine
when you are connected to the network, and when you are, flip a flag and
then use your DALC to talk directly to the big sql server.
You can mimick views (although not anything close to the real thing) by
filling a datatable with a query that corresponds to what the view was.
Although I'm not going to even touch the stored proc vs dynamic sql debate,
I can say that much of the benefit of using stored procs diminishes when
you're using a local db like Compact Edition in this manner.
You can also just bypass CE altogether. Pull down the data from sql server
into a dataset that contains everything you need to work with, interact with
that local data, buy some persistence by saving it to XML using writexml and
then when you're connected again, you can just run your Update() on the full
sql server. There's a ton of tradeoffs here so don't take this is a
recommendation, rather it's just a statement saying if you only need a
local cache of data, you don't necessarily need Compact Edition at all.
If it were mine though, i'd do as Mr Vaughn says and use it w/
synchronization.
"John" <John@.nospam.infovis.co.uk> wrote in message
news:O5clkypMIHA.4480@.TK2MSFTNGP06.phx.gbl...
> Hi
> I am developing an app in vb.net 2008 with sql server 2000 backend. I also
> need disconnected version of the app for laptop users who would connect
> off and on with LAN and thereby with the company sql server 2000. I am
> wondering if I can use sql server compact 3.5 for local caching when
> laptops are disconnected. My question is; how would my app use views and
> stored procedures in disconnected mode as sql server compact does not
> support either of these. Any help to clarify this would be appreciated.
> Thanks
> Regards
>
Disconnected app with sql server compact
Hi
I am developing an app in vb.net 2008 with sql server 2000 backend. I also
need disconnected version of the app for laptop users who would connect off
and on with LAN and thereby with the company sql server 2000. I am wondering
if I can use sql server compact 3.5 for local caching when laptops are
disconnected. My question is; how would my app use views and stored
procedures in disconnected mode as sql server compact does not support
either of these. Any help to clarify this would be appreciated.
Thanks
RegardsIf you want to use views and stored procedures, then SQL Server Compact is
not an option. However, you can use SQL Server Express, which supports
procedural T-SQL.
HTH,
Plamen Ratchev
http://www.SQLStudio.com|||The local Compact Edition database could be used for data caching. You could
write your own managed code to access it but as you found, there is no
support for SPs or Views. Your only other alternative would be to use the
Express edition on the client system which does support SPs and Views. In
either case you would want to use one of the various synchronization
paradigms to keep the two databases in sync.
____________________________________
William (Bill) Vaughn
Author, Mentor, Consultant, Dad, Grandpa
Microsoft MVP
INETA Speaker
www.betav.com
www.betav.com/blog/billva
Please reply only to the newsgroup so that others can benefit.
This posting is provided "AS IS" with no warranties, and confers no rights.
__________________________________
Visit www.hitchhikerguides.net to get more information on my latest book:
Hitchhiker's Guide to Visual Studio and SQL Server (7th Edition)
and Hitchhiker's Guide to SQL Server 2005 Compact Edition (EBook)
----
---
"John" <John@.nospam.infovis.co.uk> wrote in message
news:O5clkypMIHA.4480@.TK2MSFTNGP06.phx.gbl...
> Hi
> I am developing an app in vb.net 2008 with sql server 2000 backend. I also
> need disconnected version of the app for laptop users who would connect
> off and on with LAN and thereby with the company sql server 2000. I am
> wondering if I can use sql server compact 3.5 for local caching when
> laptops are disconnected. My question is; how would my app use views and
> stored procedures in disconnected mode as sql server compact does not
> support either of these. Any help to clarify this would be appreciated.
> Thanks
> Regards
>|||Like Bill V said, the main point is that you'd need to synchronize your
data. since there aren't views or stored procs, there's no way to do it
directly. You can create a backgroun thread or other mechanism to determine
when you are connected to the network, and when you are, flip a flag and
then use your DALC to talk directly to the big sql server.
You can mimick views (although not anything close to the real thing) by
filling a datatable with a query that corresponds to what the view was.
Although I'm not going to even touch the stored proc vs dynamic sql debate,
I can say that much of the benefit of using stored procs diminishes when
you're using a local db like Compact Edition in this manner.
You can also just bypass CE altogether. Pull down the data from sql server
into a dataset that contains everything you need to work with, interact with
that local data, buy some persistence by saving it to XML using writexml and
then when you're connected again, you can just run your Update() on the full
sql server. There's a ton of tradeoffs here so don't take this is a
recommendation, rather it's just a statement saying if you only need a
local cache of data, you don't necessarily need Compact Edition at all.
If it were mine though, i'd do as Mr Vaughn says and use it w/
synchronization.
"John" <John@.nospam.infovis.co.uk> wrote in message
news:O5clkypMIHA.4480@.TK2MSFTNGP06.phx.gbl...
> Hi
> I am developing an app in vb.net 2008 with sql server 2000 backend. I also
> need disconnected version of the app for laptop users who would connect
> off and on with LAN and thereby with the company sql server 2000. I am
> wondering if I can use sql server compact 3.5 for local caching when
> laptops are disconnected. My question is; how would my app use views and
> stored procedures in disconnected mode as sql server compact does not
> support either of these. Any help to clarify this would be appreciated.
> Thanks
> Regards
>
I am developing an app in vb.net 2008 with sql server 2000 backend. I also
need disconnected version of the app for laptop users who would connect off
and on with LAN and thereby with the company sql server 2000. I am wondering
if I can use sql server compact 3.5 for local caching when laptops are
disconnected. My question is; how would my app use views and stored
procedures in disconnected mode as sql server compact does not support
either of these. Any help to clarify this would be appreciated.
Thanks
RegardsIf you want to use views and stored procedures, then SQL Server Compact is
not an option. However, you can use SQL Server Express, which supports
procedural T-SQL.
HTH,
Plamen Ratchev
http://www.SQLStudio.com|||The local Compact Edition database could be used for data caching. You could
write your own managed code to access it but as you found, there is no
support for SPs or Views. Your only other alternative would be to use the
Express edition on the client system which does support SPs and Views. In
either case you would want to use one of the various synchronization
paradigms to keep the two databases in sync.
____________________________________
William (Bill) Vaughn
Author, Mentor, Consultant, Dad, Grandpa
Microsoft MVP
INETA Speaker
www.betav.com
www.betav.com/blog/billva
Please reply only to the newsgroup so that others can benefit.
This posting is provided "AS IS" with no warranties, and confers no rights.
__________________________________
Visit www.hitchhikerguides.net to get more information on my latest book:
Hitchhiker's Guide to Visual Studio and SQL Server (7th Edition)
and Hitchhiker's Guide to SQL Server 2005 Compact Edition (EBook)
----
---
"John" <John@.nospam.infovis.co.uk> wrote in message
news:O5clkypMIHA.4480@.TK2MSFTNGP06.phx.gbl...
> Hi
> I am developing an app in vb.net 2008 with sql server 2000 backend. I also
> need disconnected version of the app for laptop users who would connect
> off and on with LAN and thereby with the company sql server 2000. I am
> wondering if I can use sql server compact 3.5 for local caching when
> laptops are disconnected. My question is; how would my app use views and
> stored procedures in disconnected mode as sql server compact does not
> support either of these. Any help to clarify this would be appreciated.
> Thanks
> Regards
>|||Like Bill V said, the main point is that you'd need to synchronize your
data. since there aren't views or stored procs, there's no way to do it
directly. You can create a backgroun thread or other mechanism to determine
when you are connected to the network, and when you are, flip a flag and
then use your DALC to talk directly to the big sql server.
You can mimick views (although not anything close to the real thing) by
filling a datatable with a query that corresponds to what the view was.
Although I'm not going to even touch the stored proc vs dynamic sql debate,
I can say that much of the benefit of using stored procs diminishes when
you're using a local db like Compact Edition in this manner.
You can also just bypass CE altogether. Pull down the data from sql server
into a dataset that contains everything you need to work with, interact with
that local data, buy some persistence by saving it to XML using writexml and
then when you're connected again, you can just run your Update() on the full
sql server. There's a ton of tradeoffs here so don't take this is a
recommendation, rather it's just a statement saying if you only need a
local cache of data, you don't necessarily need Compact Edition at all.
If it were mine though, i'd do as Mr Vaughn says and use it w/
synchronization.
"John" <John@.nospam.infovis.co.uk> wrote in message
news:O5clkypMIHA.4480@.TK2MSFTNGP06.phx.gbl...
> Hi
> I am developing an app in vb.net 2008 with sql server 2000 backend. I also
> need disconnected version of the app for laptop users who would connect
> off and on with LAN and thereby with the company sql server 2000. I am
> wondering if I can use sql server compact 3.5 for local caching when
> laptops are disconnected. My question is; how would my app use views and
> stored procedures in disconnected mode as sql server compact does not
> support either of these. Any help to clarify this would be appreciated.
> Thanks
> Regards
>
订阅：
博文 (Atom)