Infralution Support

[soloman817]

Hi,

As so far as I know, there are 3 databases:
1) tracker database: include product info, customers, sales, keys.
2) auth server database: include product info, auth data.
3) ipn server database: include product info.

I now deployed auth server and ipn server to ASP.NET host, and they use standalone databases.

Now, the question is, where should I put the tracker database? We have two people, which we both want to use tracker, but by now, only me can use tracker, because the tracker database is on my local machine. So how can I share the database? I prefer use a mdb file, and ideal situation is, I can use tracker on my local mdb and import sales and auth data from those servers, and my parterner would also like to import sales and auth data to his local tracker mdb.

Also, if I have to use Infralution.Licensing.Data API to create some evaluation license programatically, then I saw in the demo code, it require access to tracker mdb, and this seems means, the tracker db should also be deployed online.

So, I would like to hear any suggestion and tips on how to design the database deployment.

Regards,
Xiang.

[soloman817]

BTW, I checked the mdb file of auth server, there is a table named "System" and it seems to be the key on which tracker can use it to do secure communication with auth server. So if it is a table, then I guess there might be a way to allow multiple tracker to communicate with auth server, is this true? Same, the IPN.NET, could it also communicate with multiple trackers?

[Infralution]

If you only have a couple of people using License Tracker then you can put the Access database on a shared drive and simply point each installation to the same Access file. Access is designed to manage limited database sharing like this - but if you have a large number of users then I would recommend using SQL Server.

If you are using SQL Server then you may be able to host it on your web provider and get access to the server instance locally. How you do this exactly varies from host to host. The speed of this solution will obviously depend on the speed of your connection to your host. If speed is an issue then disabling the Maintain Selection on Sort, Auto Load Child Records and/or Show Sales options may improve the performance of License Tracker.
_________________
Infralution Support