What database do you use?

[one_mind]

Hi,

I am a PHP & MySQL programmer but have recently decided to learn ASP.Net

Just wondering, do most asp.net developers use SQL Server or do you mix and match?

If SQL Server is the way to go, is it worth downloading the trial edition from ms website? It is over 800MB, can it do everything you need for developing and learning? Or should i just get the express edition?

Any info about the use of databases for asp.net app would be greatly appreciated.

Thanks :)

[mack]

You can get the free version of sql server 2005, I believe it's sql server express edition. It's not that large a file under 200 meg and has all the basic functionality you will need to start using sql with your asp.net apps

You can also download the visual basic express edition and add sql server as an optional component. If you do this you can use the MS download manager to make the file download easier.

Mack.

[one_mind]

Thanks,

On the MS website it says the express edition is for lightweight embedded db stuff.

Their trial edition is the fully functional version with a 180 day time limit.

I might just download the big one, i am using asp.net 2.0 and c# with ms visual studio 2005.