Much to my surprise, I didn't know that SQL Server Express (*.mdf) files are compatible with regular SQL Server 2008 Databases. Related problems concern "Personal.mdf" and "aspnetdb.mdf" and "club.mdf" and other files that are common with ASP.NET examples.
I always thought SQL Server Express files were stand alone data files. So, I never bothered with them. As I was trying to get a standard SQL Server installation to work as if was a "aspnetdb.mdf" database for log-in functions. I found a solution. Much to my surprise, I could attach "aspnetdb.mdf" in SQL Server Management Studio just like a regular SQL Server database. From there, scripts can be created and reused to meet your needs.
This is cool because you can convert databases back and forth using SQL Server Management Studio.
Saturday, April 3, 2010
Friday, April 2, 2010
Oracle vs Microsoft/Sun
As a developer, long ago I was a big fan of Oracle's RDMS. In those days I used it on a VAX/VMS Cluster of servers. As PCs became popular, Oracle offered a Developer's Version for a low price and it was easy to install. I used that for awhile. When Oracle started jacking-up prices, industry moved to other products. Me too! I became a big fan of Sun, Microsoft and Intergraph.
As the industry evolved, companies like Sun & Microsoft drove prices down. Eventually developers could get software for free, or almost free. Even now, most of Microsoft's development tools and server products are free for developers, students and small business. You do have to sign-up for some sort of program. Like: DreamSpark, WebsiteSpark, BizSpark or Microsoft Business Partner. Or, you can subscribe to MSDN and get almost everything. Sun's products and supported products were also free, and most still are free because of Open Source.
Now that Oracle owns Sun and is merging Sun's products into Oracle's product line things are starting to change. For example: in order to license the Solaris operating system, you now have to buy a service agreement from Oracle. Although it's still free, Oracle's development environment provides a slightly outdated database server called OracleXE. There's some other tools and a web server that goes with it. Cool! Right? Well, not when it takes 3 or 4 days to get everything to work correctly with Eclipse and Visual Studio.
When I was a VAR (Value Added Reseller) for Intergraph software & hardware, Sun always supported me even though I wasn't their representative. Silicon Graphics wouldn't give me the time of day. We all know where they went!
I predict that Microsoft, Google and Open Source are going to be the main players in the long run for software. I'm with Microsoft and Open Source. And, I'll miss Sun.
As the industry evolved, companies like Sun & Microsoft drove prices down. Eventually developers could get software for free, or almost free. Even now, most of Microsoft's development tools and server products are free for developers, students and small business. You do have to sign-up for some sort of program. Like: DreamSpark, WebsiteSpark, BizSpark or Microsoft Business Partner. Or, you can subscribe to MSDN and get almost everything. Sun's products and supported products were also free, and most still are free because of Open Source.
Now that Oracle owns Sun and is merging Sun's products into Oracle's product line things are starting to change. For example: in order to license the Solaris operating system, you now have to buy a service agreement from Oracle. Although it's still free, Oracle's development environment provides a slightly outdated database server called OracleXE. There's some other tools and a web server that goes with it. Cool! Right? Well, not when it takes 3 or 4 days to get everything to work correctly with Eclipse and Visual Studio.
When I was a VAR (Value Added Reseller) for Intergraph software & hardware, Sun always supported me even though I wasn't their representative. Silicon Graphics wouldn't give me the time of day. We all know where they went!
I predict that Microsoft, Google and Open Source are going to be the main players in the long run for software. I'm with Microsoft and Open Source. And, I'll miss Sun.
Subscribe to:
Comments (Atom)
