The database schema and programming rules will fall right out of that document.Īnother idea: programs that track books, dvds, etc. can two or more machines have the same license?). Go back and write down any rules or constraints (e.g. Write down a list of everything you want to be able to do. On the other hand, if the license tracking of your own software is key to your business, it is probably worth your time and money to develop a custom app on top of a SQL database. The downside is that you have to do more work: searching for part of a serial number to make sure it is not already in use, manually adding a note to two "contacts" indicating the transfer of a license from one to the other. (Note: I'm using Apple's address book program in my mind for referencing features) It allows for custom fields, notes, and groups. I would be extremely tempted to try and use an address book program for this to start. You start with access, use it for a couple of years, and then later hire someone to port the data into a custom app when you've outgrown that solution. This sounds like the classic kind of problem that Access (and programs like it) were designed to solve. Then you could group by computer, customer, etc. Each contact could be a program name or a customer name with the license/serial as the data. A customizable address book would work in a pinch. You just need an application that lets you create name:value pairs and assign them into groups. (Not very appealing, but not hard either) Write your own database for this Perhaps a simple app using SQLite.
Still, we need to manage how serial keys are generated.Ī couple of options (including the one you don't want):
So I'm curious if any of you have solved this same problem without writing your own custom software?Įdit: I forgot to mention, I am not asking about the merits of licensing software - the software we write is not COTS and purchases are controlled at a contractual level. I know this problem has been solved many companies license software and keep records of the serial keys they generate. I've looked around Google and various software sites, but all of the results I've found are for licensing software and creating serial keys, not managing the serial keys that those tools generate. We'd also like to track history of the computer, such as when software is removed from a computer and moved to another computer. We want software that will allows us to associate a particular computer with the software on that computer and the serial key(s) and license(s) for that software. My company is trying to find a tool that will track serial keys for software we have purchased (such as Office), as well as software that we write and sell.
0 kommentar(er)
