In the previous articles, we studied the basic rules of SQL database design, created a database schema diagram for a recruitment service, and f illed the newly-created database with test data on employees.

Img.1. The database structure diagram for a recruitment service

The database contains the following entities:

• Employee
• Company
• Position
• Project
• Skill

This time, let’s consider the ways to transfer data from one SQL Server database to another one through export and import. This can come in handy when the management system of the client database is an older version than the data source. Meaning, when it is impossible to use a backup copy or when only a part of data has to be transferred, as all data weighs too much.

#database #json #sql-server #developer