Database design

Home/Database design
13 07, 2016

Upgrading FoxPro Databases

By |2016-07-13T19:46:41+01:00July 13th, 2016|Database design|Comments Off on Upgrading FoxPro Databases

After Microsoft has cancelled support of Visual FoxPro, every owner of this database management system faced the need of migrating data to another platform due to safety and reliability reasons. There are several modern DBMS such as Oracle, SQL Server, MySQL and PostgreSQL that can be an alternative for FoxPro. By design FoxPro is a data storage having no stored procedures, triggers, views and other complex database objects. This fact [...]

12 07, 2016

Migrating MS Access databases to MySQL

By |2016-07-12T13:08:58+01:00July 12th, 2016|Database design|Comments Off on Migrating MS Access databases to MySQL

Although there are numerous tutorials on the Web that could guide you through migrating MS Access databases to MySQL server, they mainly describe conversion of the data while queries are not considered. On the other hand MS Access queries are not migrated into MySQL format by free conversion tools unlike the data. That's why you either need to convert queries manually or buy expensive products that can handle it. Here [...]

17 03, 2016

Difference between Logistics and Supply Chain Management: How SAP Business One Makes It Easy For You

By |2016-03-17T14:45:09+00:00March 17th, 2016|Database design, Logistics|Comments Off on Difference between Logistics and Supply Chain Management: How SAP Business One Makes It Easy For You

When it comes to business terminology, logistics management is just a component of the process referred to as supply chain management. It basically deals with the processes that are followed in order to make sure that goods and services are managed in a proper manner. Supply chain management is a much broader word. It deals with the chain that connects the suppliers and the end users or customers – the [...]

11 01, 2016

Access Database Templates

By |2016-01-16T11:12:06+00:00January 11th, 2016|Database design, Technology|Comments Off on Access Database Templates

Access really is a very undervalued tool that you can use within your business - its a program that can be used to create customized databases and when combined with Access database templates it is extremely powerful. What is Microsoft Access? Microsoft Access is a program from the Microsoft Office suite that deals with databases. The best part is that its actually very easy to use - even as a beginner you can [...]