Downsize from SQL Server to MSDE?

We recommend that our clients install SQL Server at each of their satellite
offices. Every night we DTS the central database out to the satellite
offices. That way, if the link goes down, or if the main server were to go
down, we'd have one or more backup databases to switch over to.
One client is looking to save on SQL Server licensing costs. They understand
that the main server will need to be SQL Server, but they're reluctant to
pay extra for additional servers which won't normally be used. They're
asking if they could have MSDE installed at the satellite offices, rather
than SQL Server, and is there any way the main SQL Server database can be
pumped down to the satellite MSDE databases nightly. Is this possible with
DTS or any other way?
If you have any suggestions or reference links, that would be very much
appreciated!
Thanks,
- Joe Geretz -
As long as the MSDE installation does not violate Microsoft's EULA for MSDE
or the database is not greater than 2GB in size or the usage of the MSDE
instances will not be hampered by the built in processing governor in MSDE,
then I would see no problem.
Jim
"Joseph Geretz" <jgeretz@.nospam.com> wrote in message
news:ulI7Pp3FEHA.712@.tk2msftngp13.phx.gbl...
> We recommend that our clients install SQL Server at each of their
satellite
> offices. Every night we DTS the central database out to the satellite
> offices. That way, if the link goes down, or if the main server were to go
> down, we'd have one or more backup databases to switch over to.
> One client is looking to save on SQL Server licensing costs. They
understand
> that the main server will need to be SQL Server, but they're reluctant to
> pay extra for additional servers which won't normally be used. They're
> asking if they could have MSDE installed at the satellite offices, rather
> than SQL Server, and is there any way the main SQL Server database can be
> pumped down to the satellite MSDE databases nightly. Is this possible with
> DTS or any other way?
> If you have any suggestions or reference links, that would be very much
> appreciated!
> Thanks,
> - Joe Geretz -
>

Downsize from SQL Server to MSDE?

We recommend that our clients install SQL Server at each of their satellite
offices. Every night we DTS the central database out to the satellite
offices. That way, if the link goes down, or if the main server were to go
down, we'd have one or more backup databases to switch over to.
One client is looking to save on SQL Server licensing costs. They understand
that the main server will need to be SQL Server, but they're reluctant to
pay extra for additional servers which won't normally be used. They're
asking if they could have MSDE installed at the satellite offices, rather
than SQL Server, and is there any way the main SQL Server database can be
pumped down to the satellite MSDE databases nightly. Is this possible with
DTS or any other way?
If you have any suggestions or reference links, that would be very much
appreciated!
Thanks,
- Joe Geretz -
As long as the MSDE installation does not violate Microsoft's EULA for MSDE
or the database is not greater than 2GB in size or the usage of the MSDE
instances will not be hampered by the built in processing governor in MSDE,
then I would see no problem.
Jim
"Joseph Geretz" <jgeretz@.nospam.com> wrote in message
news:ulI7Pp3FEHA.712@.tk2msftngp13.phx.gbl...
> We recommend that our clients install SQL Server at each of their
satellite
> offices. Every night we DTS the central database out to the satellite
> offices. That way, if the link goes down, or if the main server were to go
> down, we'd have one or more backup databases to switch over to.
> One client is looking to save on SQL Server licensing costs. They
understand
> that the main server will need to be SQL Server, but they're reluctant to
> pay extra for additional servers which won't normally be used. They're
> asking if they could have MSDE installed at the satellite offices, rather
> than SQL Server, and is there any way the main SQL Server database can be
> pumped down to the satellite MSDE databases nightly. Is this possible with
> DTS or any other way?
> If you have any suggestions or reference links, that would be very much
> appreciated!
> Thanks,
> - Joe Geretz -
>
sql

Downsize from SQL Server to MSDE?

We recommend that our clients install SQL Server at each of their satellite
offices. Every night we DTS the central database out to the satellite
offices. That way, if the link goes down, or if the main server were to go
down, we'd have one or more backup databases to switch over to.
One client is looking to save on SQL Server licensing costs. They understand
that the main server will need to be SQL Server, but they're reluctant to
pay extra for additional servers which won't normally be used. They're
asking if they could have MSDE installed at the satellite offices, rather
than SQL Server, and is there any way the main SQL Server database can be
pumped down to the satellite MSDE databases nightly. Is this possible with
DTS or any other way?
If you have any suggestions or reference links, that would be very much
appreciated!
Thanks,
- Joe Geretz -As long as the MSDE installation does not violate Microsoft's EULA for MSDE
or the database is not greater than 2GB in size or the usage of the MSDE
instances will not be hampered by the built in processing governor in MSDE,
then I would see no problem.
Jim
"Joseph Geretz" <jgeretz@.nospam.com> wrote in message
news:ulI7Pp3FEHA.712@.tk2msftngp13.phx.gbl...
> We recommend that our clients install SQL Server at each of their
satellite
> offices. Every night we DTS the central database out to the satellite
> offices. That way, if the link goes down, or if the main server were to go
> down, we'd have one or more backup databases to switch over to.
> One client is looking to save on SQL Server licensing costs. They
understand
> that the main server will need to be SQL Server, but they're reluctant to
> pay extra for additional servers which won't normally be used. They're
> asking if they could have MSDE installed at the satellite offices, rather
> than SQL Server, and is there any way the main SQL Server database can be
> pumped down to the satellite MSDE databases nightly. Is this possible with
> DTS or any other way?
> If you have any suggestions or reference links, that would be very much
> appreciated!
> Thanks,
> - Joe Geretz -
>

DownloadGenerationsPerBatch and SQLMerge

Using Merge replication.
Publisher is Sql Server 2000 SP4, subscribers are laptops using MSDE SP4.
Using anonymous subscribers that use the SQLMerge object to invoke
replication. We've run into issues where the publisher has deleted subscriber
records so we are changing all of our FKs for NFR and want to set
DownloadGenerationsPerBatch to 2000.
However, all documentation and newsgroups just talk about a command line
argument. How do I set DownloadGenerationsPerBatch on the SQLMerge object.
create a profile for this, and use the profile name option in the activeX
merge object - ie ProfileName
But I think you could solve your problem by using
compensate_for_errors=false in sp_addmergearticle
Consult this kb for more info
http://support.microsoft.com/kb/828637
Hilary Cotter
Looking for a SQL Server replication book?
http://www.nwsu.com/0974973602.html
Looking for a FAQ on Indexing Services/SQL FTS
http://www.indexserverfaq.com
"Buzz" <buzz@.online.nospam> wrote in message
news:C26C42E3-906B-4CFA-ADBE-81183E43C890@.microsoft.com...
> Using Merge replication.
> Publisher is Sql Server 2000 SP4, subscribers are laptops using MSDE SP4.
> Using anonymous subscribers that use the SQLMerge object to invoke
> replication. We've run into issues where the publisher has deleted
subscriber
> records so we are changing all of our FKs for NFR and want to set
> DownloadGenerationsPerBatch to 2000.
> However, all documentation and newsgroups just talk about a command line
> argument. How do I set DownloadGenerationsPerBatch on the SQLMerge object.
>
|||Thanks for pointing me in the right direction! Both with profiles and the new
article option!
"Hilary Cotter" wrote:

> create a profile for this, and use the profile name option in the activeX
> merge object - ie ProfileName
> But I think you could solve your problem by using
> compensate_for_errors=false in sp_addmergearticle
> Consult this kb for more info
> http://support.microsoft.com/kb/828637
> --
> Hilary Cotter
> Looking for a SQL Server replication book?
> http://www.nwsu.com/0974973602.html
> Looking for a FAQ on Indexing Services/SQL FTS
> http://www.indexserverfaq.com
> "Buzz" <buzz@.online.nospam> wrote in message
> news:C26C42E3-906B-4CFA-ADBE-81183E43C890@.microsoft.com...
> subscriber
>
>
sql

Downgrading SQLServer to MSDE

Hi,
I am pretty new to MSDE and am just researching options for writing a .NET
version of a desktop application (currently VB6 / Access).
There is a web version of our product available already which has a SQL
Server backend.
I am figuring that I will use MSDE so I can use all their Stored procedures
and as much code of theirs as possible.
What I am wondering is if I can get downgrade from SQL Server to MSDE ?
There's lots of information about upgrading, but nothing about downgrading.
Thanks
Sanj
hi,
Sanjit Suchak wrote:
> Hi,
> I am pretty new to MSDE and am just researching options for writing a
> .NET version of a desktop application (currently VB6 / Access).
> There is a web version of our product available already which has a
> SQL Server backend.
> I am figuring that I will use MSDE so I can use all their Stored
> procedures and as much code of theirs as possible.
> What I am wondering is if I can get downgrade from SQL Server to MSDE
> ? There's lots of information about upgrading, but nothing about
> downgrading.
downgrading is a viable solution as long as you take into consideration all
relevant MSDE limitations..
2gb database size, limited replication support, no OLAP features, no
Reporting Services... and limited number of users scenarios... these are the
most relevant of them in my opinion... but the core features are all
available...
Andrea Montanari (Microsoft MVP - SQL Server)
http://www.asql.biz/DbaMgr.shtmhttp://italy.mvps.org
DbaMgr2k ver 0.14.0 - DbaMgr ver 0.59.0
(my vb6+sql-dmo little try to provide MS MSDE 1.0 and MSDE 2000 a visual
interface)
-- remove DMO to reply

downgrade MSDE 2000 sp4

I Can attach db from MDSE 2000 Sp4 to MSDE 2000 Sp3a?
hi Antonio,
Antonio Arienzo wrote:
> I Can attach db from MDSE 2000 Sp4 to MSDE 2000 Sp3a?
you probably can attach a user database on different service pack level...
sometime (but rarely) this result in exception, but you usually can...
Andrea Montanari (Microsoft MVP - SQL Server)
http://www.asql.biz/DbaMgr.shtmhttp://italy.mvps.org
DbaMgr2k ver 0.14.0 - DbaMgr ver 0.59.0
(my vb6+sql-dmo little try to provide MS MSDE 1.0 and MSDE 2000 a visual
interface)
-- remove DMO to reply

Down Sizing from SQL server to MSDE?

Hi everyone,
Does anyone know if I can take tables from SQL server and somehow get them
into MSDE. I'm using Access as a front end to both servers. I know there is
a way to upsize databases, as well there should be, but what are my options
in terms of downsizing?
Thanks everyone
Take Care
SimonScripting the tables and then using INSERT INTO should work fine.
--
--
Allan Mitchell (Microsoft SQL Server MVP)
MCSE,MCDBA
www.SQLDTS.com
I support PASS - the definitive, global community
for SQL Server professionals - http://www.sqlpass.org
"Simon Harvey" <sh856531@.microsofts_free_emal_service.com> wrote in message
news:SerXa.52566$9C6.3100247@.wards.force9.net...
> Hi everyone,
> Does anyone know if I can take tables from SQL server and somehow get them
> into MSDE. I'm using Access as a front end to both servers. I know there
is
> a way to upsize databases, as well there should be, but what are my
options
> in terms of downsizing?
> Thanks everyone
> Take Care
> Simon
>|||I think I'd try sp_detachdb and sp_attachdb and see if that works ( it
should I think.)
--
Wayne Snyder, MCDBA, SQL Server MVP
Computer Education Services Corporation (CESC), Charlotte, NC
www.computeredservices.com
(Please respond only to the newsgroups.)
I support the Professional Association of SQL Server (PASS) and it community
of SQL Server professionals.
www.sqlpass.org
"Simon Harvey" <sh856531@.microsofts_free_emal_service.com> wrote in message
news:SerXa.52566$9C6.3100247@.wards.force9.net...
> Hi everyone,
> Does anyone know if I can take tables from SQL server and somehow get them
> into MSDE. I'm using Access as a front end to both servers. I know there
is
> a way to upsize databases, as well there should be, but what are my
options
> in terms of downsizing?
> Thanks everyone
> Take Care
> Simon
>

Double Byte Character Support?

I have a Point of Sale System which uses SQL (MSDE or SQL
2000) as the back end database. We have a client that
wants to buy a Chinese version of the Point of Sale
System...so my question is, does SQL 2000 or MSDE support
the double byte character set? Is there anything special I
need to do to accomplish this, or is there a special
version of SQL to buy?Hi Ray
SQL Server supports double byte character sets ("unicode")
Types NCHAR, NVARCHAR NTEXT are unicode (double byte)
Types CHAR, VARCHAR, TEXT are single byte.
There are also collations which cover language character sets & sort orders
as well.
This applies to all editions of SQL Server.
HTH
Regards,
Greg Linwood
SQL Server MVP
"Ray" <rkano@.adctech.com> wrote in message
news:0f9601c38dfc$b9366290$a001280a@.phx.gbl...
> I have a Point of Sale System which uses SQL (MSDE or SQL
> 2000) as the back end database. We have a client that
> wants to buy a Chinese version of the Point of Sale
> System...so my question is, does SQL 2000 or MSDE support
> the double byte character set? Is there anything special I
> need to do to accomplish this, or is there a special
> version of SQL to buy?

don't allow duplicates problem

I have MSDE with the server tools from sql server 2000 enterprise edition. I
am having a problem with one of my tables. The table is set up with two
fields Class and Student. I want there to be only one student of the same
name in each class. If i use the primary key it will just allow only one
student of the same name in the entire table and wouldn't look at the class
that the student is taking. Is there an easy way around this?
I found a solution, I created a dual primary key. I highlighted both items
and then turned on the primary key and it does exactly what I wanted it to
except the maximum size is 900bytes for a primary key so I had to adjust the
length of the fields a bit.
"Benjamin" wrote:

> I have MSDE with the server tools from sql server 2000 enterprise edition. I
> am having a problem with one of my tables. The table is set up with two
> fields Class and Student. I want there to be only one student of the same
> name in each class. If i use the primary key it will just allow only one
> student of the same name in the entire table and wouldn't look at the class
> that the student is taking. Is there an easy way around this?

Donno how to work on MSDE?

Hi,

I downloaded and installed MSDE successfully on my comp, but since i have this practice of creating my data base, tables.. using the enterprise manager, i donno how exactly to do the same in. MSDE.

I am new to MSDE, so plz someone explain me to create the database and the tables in MSDE.

and another question is that.. i have created 2 instances of the same.. but donno what these instances exactly are ?

can anyone plz explain me all these..?

Try downloading The ASP Enterprise Manager, which is a web based toolwhich allows you to do many Enterprise Manager type tasks in MSDEwithout SQLEM.
http://www.aspenterprisemanager.com/
Jason