SQL Server/MSDE Question (Coexistence?)  
Author Message
AshMSfan





PostPosted: Mon Oct 20 18:06:35 CDT 2003 Top

SQL Server >> SQL Server/MSDE Question (Coexistence?)

Hi,

I am developing a software package (VB.NET) that will be used on a
desktop/server that does NOT have SQL Server. I am planning on using MSDE.
But, I will be developing the app on my system which DOES have SQL Server so
I want to take advantage of Enterprise Manager, etc. Can I make MSDE a
server under the control of SQL Server, but "detach" it and move it to
another site in the future? (Probably not asking the right questions, but
hopefully you will understand what I want to do). BTW, I will be MORE than
happy to read up on this on my own if you point me in the direction.

TIA,

Larry Woods

SQL Server86  
 
 
NEW





PostPosted: Mon Oct 20 18:06:35 CDT 2003 Top

SQL Server >> SQL Server/MSDE Question (Coexistence?) yes you can develop your app on your laptop with MSDE installed locally as
the backend. When you are ready you just need to copy the DB to production
server and tell your app where to look for production server.

hth,





> Hi,
>
> I am developing a software package (VB.NET) that will be used on a
> desktop/server that does NOT have SQL Server. I am planning on using
MSDE.
> But, I will be developing the app on my system which DOES have SQL Server
so
> I want to take advantage of Enterprise Manager, etc. Can I make MSDE a
> server under the control of SQL Server, but "detach" it and move it to
> another site in the future? (Probably not asking the right questions, but
> hopefully you will understand what I want to do). BTW, I will be MORE
than
> happy to read up on this on my own if you point me in the direction.
>
> TIA,
>
> Larry Woods
>
>
>


 
 
Larry





PostPosted: Mon Oct 20 19:05:18 CDT 2003 Top

SQL Server >> SQL Server/MSDE Question (Coexistence?) Thanks.

Sorry for the ignorance, but do I just register it in my server group? I
guess I don't understand how to treat MSDE when I also have SQL Server on
the same computer--since MSDE IS SQL Server!

Larry



> yes you can develop your app on your laptop with MSDE installed locally as
> the backend. When you are ready you just need to copy the DB to
production
> server and tell your app where to look for production server.
>
> hth,
>
>
>


> > Hi,
> >
> > I am developing a software package (VB.NET) that will be used on a
> > desktop/server that does NOT have SQL Server. I am planning on using
> MSDE.
> > But, I will be developing the app on my system which DOES have SQL
Server
> so
> > I want to take advantage of Enterprise Manager, etc. Can I make MSDE a
> > server under the control of SQL Server, but "detach" it and move it to
> > another site in the future? (Probably not asking the right questions,
but
> > hopefully you will understand what I want to do). BTW, I will be MORE
> than
> > happy to read up on this on my own if you point me in the direction.
> >
> > TIA,
> >
> > Larry Woods
> >
> >
> >
>
>


 
 
Tibor





PostPosted: Tue Oct 21 03:31:06 CDT 2003 Top

SQL Server >> SQL Server/MSDE Question (Coexistence?) How about developing on a Developer Edition, detach (or backup etc) the database and deploy that on
the end users' MSDE? Here's good info on MSDE, btw:
http://www.microsoft.com/sql/msde/howtobuy/msdeuse.asp

--
Tibor Karaszi, SQL Server MVP
Archive at: http://groups.google.com/groups?oi=djq&as ugroup=microsoft.public.sqlserver



> Hi,
>
> I am developing a software package (VB.NET) that will be used on a
> desktop/server that does NOT have SQL Server. I am planning on using MSDE.
> But, I will be developing the app on my system which DOES have SQL Server so
> I want to take advantage of Enterprise Manager, etc. Can I make MSDE a
> server under the control of SQL Server, but "detach" it and move it to
> another site in the future? (Probably not asking the right questions, but
> hopefully you will understand what I want to do). BTW, I will be MORE than
> happy to read up on this on my own if you point me in the direction.
>
> TIA,
>
> Larry Woods
>
>
>


 
 
v-yshao





PostPosted: Tue Oct 21 04:31:02 CDT 2003 Top

SQL Server >> SQL Server/MSDE Question (Coexistence?) Hi Larry,

I'm including some supplemental information below:

Desktop Engine implements all of the basic functionality of SQL Server
2000, as well as most of the additional services. There are, however, a few
differences to keep in mind while planning your installation:

1. The size of Desktop Engine databases cannot exceed 2 gigabytes (GB).

2. Desktop Engine supports symmetric multiprocessing on a maximum of two
processors.

3. Desktop Engine uses the same concurrent workload governor as SQL Server
2000 Personal Edition. When more than five batches are run concurrently,
the workload governor will insert no-ops in direct proportion to the number
of excess batches submitted for processing, thereby reducing system
performance.

4. Desktop Engine participates in replication as:
a. A Subscriber in transactional replication.
b. Both Subscriber and Publisher in snapshot and merge replication.

5. Desktop Engine does not support SQL Mail.

6. Desktop Engine is not supported on Windows? Advanced Server, Limited
Edition.

For additional information regarding the MSDE, please refer to the
following articles below:
321518 INFO: When to Choose MSDE 2000 as the Database Engine for Your
http://support.microsoft.com/?id=321518

817788 Support WebCast: Microsoft SQL Server 2000 Desktop Engine (MSDE)
http://support.microsoft.com/?id=817788

SQL Server 2000 Databases on the Desktop
http://msdn.microsoft.com/library/default.asp?url=/library/en-us/architec/8_
ar_sa2_9gz4.asp

Thanks for using MSDN newsgroup.

Regards,

Michael Shao
Microsoft Online Partner Support
Get Secure! - www.microsoft.com/security
This posting is provided "as is" with no warranties and confers no rights.

 
 
Larry





PostPosted: Tue Oct 21 17:34:56 CDT 2003 Top

SQL Server >> SQL Server/MSDE Question (Coexistence?) Thanks to all...

I'm going to have to dig out the books...and check out the SQL Doc. I
installed MSDE on my computer that already has SQL Server...and it corrupted
SQL Server! Say's that I have to uninstall and reinstall SQL Server.

Hmmmmmm.

Larry



> How about developing on a Developer Edition, detach (or backup etc) the
database and deploy that on
> the end users' MSDE? Here's good info on MSDE, btw:
> http://www.microsoft.com/sql/msde/howtobuy/msdeuse.asp
>
> --
> Tibor Karaszi, SQL Server MVP
> Archive at: http://groups.google.com/groups?oi=djq&as
ugroup=microsoft.public.sqlserver
>
>


> > Hi,
> >
> > I am developing a software package (VB.NET) that will be used on a
> > desktop/server that does NOT have SQL Server. I am planning on using
MSDE.
> > But, I will be developing the app on my system which DOES have SQL
Server so
> > I want to take advantage of Enterprise Manager, etc. Can I make MSDE a
> > server under the control of SQL Server, but "detach" it and move it to
> > another site in the future? (Probably not asking the right questions,
but
> > hopefully you will understand what I want to do). BTW, I will be MORE
than
> > happy to read up on this on my own if you point me in the direction.
> >
> > TIA,
> >
> > Larry Woods
> >
> >
> >
>
>


 
 
v-yshao





PostPosted: Wed Oct 22 09:51:56 CDT 2003 Top

SQL Server >> SQL Server/MSDE Question (Coexistence?) Hi Larry,

Thanks for your feedback. I notice that you create a new thread "Did
Uninstall/Reinstall of SQL Server. Now databases are under WRONG servers"
in the group microsoft.public.sqlserver.server. Does that post relate to
this problem? If so, I would like to work with you in the new post
continuously next time.

According to your description, I am not sure the version of MSDE and SQL
Server. I assume that they are MSDE 2000 and SQL Server 2000. If I have
misunderstood, please feel free to let me know.

How do you install the MSDE? For additional information regarding
installation of MSDE, please refer to the following article on SQL Server
Books Online.
Topic: "Customizing Desktop Engine Setup.exe"

317328 HOW TO: Troubleshoot a SQL Server Desktop Engine 2000 Installation
and
http://support.microsoft.com/?id=317328

Also, how do you think that the installation of MSDE corrupt the SQL
Server? Can you describe it in detail? It seems that there are some error
messages appearing. Please post the detailed error message so that I can
perform further research.

I am standing by for your response.

Regards,

Michael Shao
Microsoft Online Partner Support
Get Secure! - www.microsoft.com/security
This posting is provided "as is" with no warranties and confers no rights.

 
 
Larry





PostPosted: Thu Oct 30 16:40:36 CST 2003 Top

SQL Server >> SQL Server/MSDE Question (Coexistence?) I'll look into it. Obviously, I'm "green" at this so any help is MUCH
appreciated.

Larry



> How about developing on a Developer Edition, detach (or backup etc) the
database and deploy that on
> the end users' MSDE? Here's good info on MSDE, btw:
> http://www.microsoft.com/sql/msde/howtobuy/msdeuse.asp
>
> --
> Tibor Karaszi, SQL Server MVP
> Archive at: http://groups.google.com/groups?oi=djq&as
ugroup=microsoft.public.sqlserver
>
>


> > Hi,
> >
> > I am developing a software package (VB.NET) that will be used on a
> > desktop/server that does NOT have SQL Server. I am planning on using
MSDE.
> > But, I will be developing the app on my system which DOES have SQL
Server so
> > I want to take advantage of Enterprise Manager, etc. Can I make MSDE a
> > server under the control of SQL Server, but "detach" it and move it to
> > another site in the future? (Probably not asking the right questions,
but
> > hopefully you will understand what I want to do). BTW, I will be MORE
than
> > happy to read up on this on my own if you point me in the direction.
> >
> > TIA,
> >
> > Larry Woods
> >
> >
> >
>
>


 
 
v-yshao





PostPosted: Fri Oct 31 00:36:00 CST 2003 Top

SQL Server >> SQL Server/MSDE Question (Coexistence?) Hi Larry,

It seems that the problem in this issue is similar with the one in the post
titled "Did Uninstall/Reinstall of SQL Server. Now databases are under
WRONG servers"
If I have misunderstood, please feel free to let me know.

According to your description in that post, everything looks worked fine. I
am unable to find any abnormal thing. Currently, does any problem occur?
Please feel to post in the group, if you encounter any problem on your
machine, I am glad to work with you.

Thanks for using MSDN newsgroup.

Regards,

Michael Shao
Microsoft Online Partner Support
Get Secure! - www.microsoft.com/security
This posting is provided "as is" with no warranties and confers no rights.

 
 
Larry





PostPosted: Fri Oct 31 05:34:56 CST 2003 Top

SQL Server >> SQL Server/MSDE Question (Coexistence?) Thanks for you persistence, Micheal. It looks like everything is "glued"
together correctly. I will be working on it this weekend. If I have any
other problems you can be SURE that I will get back to you.

Thanks, again.

Larry



> Hi Larry,
>
> It seems that the problem in this issue is similar with the one in the
post
> titled "Did Uninstall/Reinstall of SQL Server. Now databases are under
> WRONG servers"
> If I have misunderstood, please feel free to let me know.
>
> According to your description in that post, everything looks worked fine.
I
> am unable to find any abnormal thing. Currently, does any problem occur?
> Please feel to post in the group, if you encounter any problem on your
> machine, I am glad to work with you.
>
> Thanks for using MSDN newsgroup.
>
> Regards,
>
> Michael Shao
> Microsoft Online Partner Support
> Get Secure! - www.microsoft.com/security
> This posting is provided "as is" with no warranties and confers no rights.
>