I was just spinning up a little console application, as a utility, and I'm pulling an encrypted connection string from the app.config file. Using 1.1 code that I'm used to, I used....
System.Configuration.ConfigurationSettings.AppSettings["connstr"].ToString();
And the compiler gave me the following error.
Warning 1 'System.Configuration.ConfigurationSettings.AppSettings' is obsolete: 'This method is obsolete, it has been replaced by ConfigurationManager.AppSettings'
So I try and change my Code to the following ...
System.Configuration.ConfigurationManager.AppSettings["connstr"].ToString();
and I get a compiler error, saying the compiler can't find ConfigurationManager.
Well here's the confusion.... The Original System.Configuration.ConfigurationSettings class is found in the System.dll assembly. There is a new assembly with all the new ConfigurationManager classes as System.Configuration.dll. Before using the ConfigurationManager class, you must first set a reference to the new System.Configuration.dll.
-=- Hope this helps someone ....
I've just read both of Joe Celko's books on SQL (Smarties and Trees/Hierarchies) and I'm just throwing a line out to see if anyone else has feedback.
Are the SQL Procs online somewhere that I can modify/massage to my data, without having to re-key them all? Surely there is a resource for this somewhere, but my Google searches are coming up empty. I'm looking for SQL Server 2000 implementations.
Another idea, is to leave SQL 2000 behind, and start using the "WITH" implementation of SQL Server 2005.
I just installed and started using Red-Gate.com SQL Backup Utility, and I can't believe the difference in speed and file size.
I'm using this to backup my www.KBAlertz.com database, which is around 4.5 gig. Not huge, but all the backups were filling up my drive, so I went looking for an alternative to the Ent.Man. built in backups.
Enterprise Manger Backup
Time : 5 minutes to backup.
Original Database size : 4,503,488
Backup Size : 4,462,324 K
Red-Gate SQL Backup
78 Seconds to do full backup
Original Database size : 4,503,488
Backup File Size : 487,115K + 484,910K (Split Files)
More than 4 times smaller, and more than 4 times faster. NICE!
One thing I don't like, is that it doesn't look like I can backup all my database files at once. I have to script each one, then setup a job for each database, where in Ent.Man. I could group database's together to be backed up as a group.
If someone knows about this option, or how to do it, please let me know.
2006 May 23
Update: There is a very nice script that the red-gate support forums has online, that allows you to backup all of your databases at once. It even has a master table, that lists each of your database's, and let's you include exclude, and determine teh number of days to keep old backups around before they get deleted. Very nice script.