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]

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...;en-us;Q314546

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

John

"lathem" <la****@ns.mindspring.com> wrote in message
news:yA******************@newsread1.news.atl.earth link.net...

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

[Dan Guzman]

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" <la****@ns.mindspring.com> wrote in message
news:yA******************@newsread1.news.atl.earth link.net...

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