Preserve Relations Between Entities. To Be or Not to Besaves much time and efforts for people around the globe but still every automated procedure has some requirements. In this article, we would like to explain how relations between entities can be preserved on your new store. In addition, you will find useful tips on how to benefit from saving or breaking connections between database tables of online shop.


At first, let’s explain what it means to preserve relations between entities including products, customers, orders, etc.

Preserve Relations Between Entities. To Be or Not to Be

In every online retailer there are items that belong to exact pages, sections and so on. For instance, order that includes ordered products is connected to the products quantity and users account page. This simple connections create an entity relationship diagram, that shows the business rules that apply to an organization's data.

Pros of Saving Relations Between Entities

In case you wish to save the logical structure and preserve relations on a Target Store, ,b>all entities should be moved at once. New order page will link to new product pages and customers will be able to view their orders without any modifications. Also, a store owner will have an opportunity to manage orders on a new store with no delays. However, if you’ve migrated products with customers at once and orders in a different transfer, the relations will be lost.

Useful Tip. If your entities are transferred all-at-once, the relations between items will be preserved on a Target Store.

Pros of Breaking Relations Between Entities

Sometimes, there is no need to preserve connections between store data. It may include different situations from launching a completely new online retailer with old customers to creating a new accounting system for a new store. As an example, merchant may launch a new store from scratch with completely different products. That means there is no need to migrate products from the source Source Store, but it is important to transfer customers.

Moreover, store owners can save money since the price of transfer is calculated in accordance to the number of entities that you wish to move. Therefore, the less items you’ve selected - the less credits you will need to pay.

Useful Tip. Using additional option called Preserve customer IDs on a Target Store can make store management after migration much easier.

To sum up, if you have a clue how service works, it is much easier to get the best results. Now you know what is relations between entities and can decide if you need to preserve them. So, dispel all doubts that hold over your desirable switch to a new platform. Register now, and move your entities saving or breaking relations between them.