Design an updateable database to store data received from another source.

 

Design an updateable database to store data received from another source.

SQL has the capacity to collect data sent to it from the outside sources and store it in its tables. As can be seen in Figure 1 that SQL can get data from multiple source. To store data from another source, the basic design of the database has to be writeable.

Figure 1

INSERT INTO [destination database].[dbo].[destination table];

SELECT *

FROM [source database].[dbo].[source table];

The above query is a general design of importing data into a host database from another database. The destination and source databases and the respective tables have to be identified with the help of the query.