SQL Server software - Minimum needed to work with Office XP Professional.

[Ghost]

I currently have office xp professional installed on my computer. I have to
upsize an access database that only includes tables to SQL Server 2000.

What is the minimum software needed to make above happen? Can I just buy the
SQL server disk? If so, where is a good place to look? I don't want to
spend six or seven hundred dollars to get the full blown Windows Office XP
Developers version.

Any assistance is greatly appreciated.


Frank

 

[Albert D. Kallal]

You don't need to purchase anything to design, and develop sql server stuff.

On every copy of the office cd is a free version of sql server. So, you can
use that to test, and do your migration.

Do note that this free version of sql server (MSDE) does NOT include the
standard enterprise tools that sql server has.

however, what you can do is go and grab the free trial edition of sql
server, download it, and ONLY install the client tools. This will thus get
you all the tools like Enterprise manger and query analyzer. Just don't
installed the sql server part, as that has an expire date, and further, you
already have a sql server engine included for use with ms-access on the
office cd anway...

So, your total cost of getting sql server, and the enterprise tools to build
and test this migration is zero.

 

[Ghost]

Al:

Thanks a ton for your assistance. Went to my office XP CD and installed SQL
Server 2000. I also installed the SP 3 updater.

Everything works fine.

Thanks again for your assistance.

Frank

PS: Where is best site for free download in get developer tools

 

[Jim Evans]

Search Microsoft for MSDE (Microsoft Desktop Engine), it's a scaled down
version of SQL 2K and it's free.

Jim Evans

 

[John Vinson]

You don't need to purchase anything to design, and develop sql server stuff.

On every copy of the office cd is a free version of sql server. So, you can
use that to test, and do your migration.

Do note that this free version of sql server (MSDE) does NOT include the
standard enterprise tools that sql server has.

however, what you can do is go and grab the free trial edition of sql
server, download it, and ONLY install the client tools. This will thus get
you all the tools like Enterprise manger and query analyzer. Just don't
installed the sql server part, as that has an expire date, and further, you
already have a sql server engine included for use with ms-access on the
office cd anway...

So, your total cost of getting sql server, and the enterprise tools to build
and test this migration is zero.

The only niggling little constraint (which might not matter in this
case) is that the MSDE engine is limited to five concurrent threads
and (more importantly) to 2GByte.

John W. Vinson[MVP]
Join the online Access Chats
Tuesday 11am EDT - Thursday 3:30pm EDT
http://community.compuserve.com/msdevapps

 

[Jim Davenport]

I currently have office xp professional installed on my computer. I have to
upsize an access database that only includes tables to SQL Server 2000.

What is the minimum software needed to make above happen? Can I just buy the
SQL server disk? If so, where is a good place to look? I don't want to
spend six or seven hundred dollars to get the full blown Windows Office XP
Developers version.

Any assistance is greatly appreciated.


Frank

Try Provantage.com and see if you qualify for Academic
Licensing, or maybe your nephew does.

 

[Ghost]

Thanks all for most helpful comments. Downloaded SQL from my office XP home
disk then went to Microsoft web site and downloaded trial version of SQL and
only installed the support tools. Everything, to date, is working fine.

Thanks again for your most kind and timely support.

Ghost