Can I use SQL Server 2008 in Windows 7? If yes is it possible to make client and server in one system for programming purposes?
Can I use SQL Server 2008 in Windows 7? If yes is it possible to make client and server in one system for programming purposes?
Yes and yes. I'm running the Server on my Windows 7 machine now. I've also got an early release of 2008 R2 running on a virtual on my Windows 7 machine. It's absolutely set up to make this work so that you can do full development on an isolated box.
Only thing is that you want to be running SP1 under Windows7 ideally - you can get that here. I haven't heard anyone complaining that their cat caught fire because they weren't running SP1, but it can't do any harm.
If you want to run 2005 as well (which is advisable from a development perspective, especially if your database needs to run on both platforms), then you need to be running SP3 of that, which you can get here. Again, no reports of feline incendiary moments...
No one has followed this question yet.