/dev/GON.clblog respaldo anti-amnesia

My first deployment attempt with my fingerprint reader application was not very good.

First, I was informed late about the version that ran the server: SQL Server 7. Moreover, it is difficult to go any time to make room for any evidence, even worse to sit quiet coding. The first thing we tried long ago, was to make a backup of the entire database. Assuming Microsoft Management Studio would be enough to connect to the database and create new tables, has been the first thing I thought to do that day.

But as Murphy’s law is always, I found an uncomfortable message, saying Unable to connect to an earlier version of SQL Server lower to 2000 (ie, version 8). Because Management Studio is based on. NET, I doubted that my .NET application could connect. Later, I discovered that I was wrong, but at the time I had no alternative other than to evaluate more solutions.

Read the rest of this entry »

And the weight, wan’t the joke.

Following the delayed “fingerprint reader for access control” project , I ran into a problem of those …

The present application of access control works with SQL Server 7 on Windows 2000, a bad living relic. The tool of handling of the data base (SQL Management) associated to that version, is a true mystery in functionalities. For some reason, “Generate SQL querys” from a data base, it only generates the models of the tables, but no record. Finally I could not recover this data, because generating a full backup or dumping to a flat text file, threw a pretty “unknown error”.

Not who did it, but today I received a DVD with 900MB of tables and records of those bases. The file was a backup respaldo.bkp.

The first thing I did was try to play with him :p :

Read the rest of this entry »