I personally use SQL Server.
You will find 2 databases,
old and also the
Databases relational structures are the identical.
The main difference is:
- Some posts in a single table are missing
- Some posts have different game titles
- Some posts in a replacement are added
Now you ask , to obtain the method to import data from old database to a different one.
Make use of the
Import Data Wizard in SSMS to accomplish the job:
It'll take you step-by-step through the steps. Read more here.
you are able to write a select into query, but consider eric's method first. I am only adding this as a substitute.
USE AdventureWorks2008R2; GO SELECT c.FirstName, c.LastName, e.JobTitle, a.AddressLine1, a.City, sp.Name AS [State/Province], a.PostalCode INTO dbo.EmployeeAddresses FROM Person.Person AS c JOIN HumanResources.Employee AS e ON e.BusinessEntityID = c.BusinessEntityID JOIN Person.BusinessEntityAddress AS bea ON e.BusinessEntityID = bea.BusinessEntityID JOIN Person.Address AS a ON bea.AddressID = a.AddressID JOIN Person.StateProvince as sp ON sp.StateProvinceID = a.StateProvinceID; GO
with "as" claims you should write the column names from the destination, to ensure that the posts match.