vrijdag, november 03, 2006
Databases
Any decent web application needs a good, reliable and fast database behind. Because my chosen platform ASP.NET is so integrated with MS SQL Server, that will be the one. And I have two MS SQL databases included in my web hosting package.
But it's a steap learning curve. Oh, I long for the days of Paradox databases and Delphi where I just had to copy over a bunch of files. Yesterday, I lost hours to figure out how to migrate an exiting SQL 2000 database to a SQL 2005 server. (The database for Feedback Server, a commercial but affordable and excellent survey tool - there is also a limited free version available.)
I was using Microsoft's own SQL Management Studio tool, but for some reason only the structure of the table got copied over, not the data or indices, keys, constraints etc. I got it working eventually but boy...
One of the tools I would have liked discoved earlier was an add-on to SQL Management Studio that allows for scripting the table content (for some reason SQL Management Studio doesn't do that), like on codeproject: http://www.codeproject.com/useritems/enisey.asp.
Another tool I stumbled accross was SQL Manager Lite, you can find it on http://www.sqlmanager.net/en/products/mssql/manager.
Be sure to download the lite, free version. It allows to script a database, so you can easily port it to another one.
Anyway, I'm done now. It works and that what's counting!
But it's a steap learning curve. Oh, I long for the days of Paradox databases and Delphi where I just had to copy over a bunch of files. Yesterday, I lost hours to figure out how to migrate an exiting SQL 2000 database to a SQL 2005 server. (The database for Feedback Server, a commercial but affordable and excellent survey tool - there is also a limited free version available.)
I was using Microsoft's own SQL Management Studio tool, but for some reason only the structure of the table got copied over, not the data or indices, keys, constraints etc. I got it working eventually but boy...
One of the tools I would have liked discoved earlier was an add-on to SQL Management Studio that allows for scripting the table content (for some reason SQL Management Studio doesn't do that), like on codeproject: http://www.codeproject.com/useritems/enisey.asp.
Another tool I stumbled accross was SQL Manager Lite, you can find it on http://www.sqlmanager.net/en/products/mssql/manager.
Be sure to download the lite, free version. It allows to script a database, so you can easily port it to another one.
Anyway, I'm done now. It works and that what's counting!
