Deployment / Version Questions

[lathem]

I'm going to write an application for a friend's business using VS .NET and
SQL Server 2000. I'm confused though as to how I can write everything on my
laptop, then copy to their server. I have an MSDN subscription and did not
realize that I cannot install the Enterprise Edition of SQL Server on XP
Pro. I can install the development edition, but am I then going to run into
problems trying to copy it over to their server?

My experience lies in Informix / DB2 and Java / JDBC, so this is new
territory for me and I appreciate the help.

Derrick Lathem

[John Bell]

Re: Deployment / Version Questions

Hi

On your the destination you will have to install a new copy of SQL that is
correctly licenced. In general I don't think your MSDN licence will not
cover their systems, although you may be able to distribute MSDE. You should
read http://www.microsoft.com/sql/techinf...skChooseEd.asp to
see which edition is most appropriate for your needs. For MSDE check out the
web site http://www.microsoft.com/sql/MSDE/

To get your database onto the destination system there are several ways, the
easiest is probably to detach/attach the database, but you could use one of
several other methods see:

http://support.microsoft.com/default.aspx?scid=kb;en-us;Q314546

You should also make sure that the logins are correctly set up on the
destination system.

John

"lathem" <lathem@ns.mind spring.com> wrote in message
news:yA3Ob.1183 0$i4.10805@news read1.news.atl. earthlink.net.. .[color=blue]
> I'm going to write an application for a friend's business using VS .NET[/color]
and[color=blue]
> SQL Server 2000. I'm confused though as to how I can write everything on[/color]
my[color=blue]
> laptop, then copy to their server. I have an MSDN subscription and did[/color]
not[color=blue]
> realize that I cannot install the Enterprise Edition of SQL Server on XP
> Pro. I can install the development edition, but am I then going to run[/color]
into[color=blue]
> problems trying to copy it over to their server?
>
> My experience lies in Informix / DB2 and Java / JDBC, so this is new
> territory for me and I appreciate the help.
>
> Derrick Lathem
>
>[/color]

[Dan Guzman]

Re: Deployment / Version Questions

To add to John's response, the SQL Server Developer edition provides the
same features as the Enterprise edition but is licensed only for development
use. This is the appropriate choice for development if you are targeting a
server edition of SQL Server. It is included with MSDN Universal and
Enterprise subscriptions or can be acquired separately for about $50.

--
Hope this helps.

Dan Guzman
SQL Server MVP

"lathem" <lathem@ns.mind spring.com> wrote in message
news:yA3Ob.1183 0$i4.10805@news read1.news.atl. earthlink.net.. .[color=blue]
> I'm going to write an application for a friend's business using VS .NET[/color]
and[color=blue]
> SQL Server 2000. I'm confused though as to how I can write everything on[/color]
my[color=blue]
> laptop, then copy to their server. I have an MSDN subscription and did[/color]
not[color=blue]
> realize that I cannot install the Enterprise Edition of SQL Server on XP
> Pro. I can install the development edition, but am I then going to run[/color]
into[color=blue]
> problems trying to copy it over to their server?
>
> My experience lies in Informix / DB2 and Java / JDBC, so this is new
> territory for me and I appreciate the help.
>
> Derrick Lathem
>
>[/color]