Data migration process within SQL server -
i have requirement this.
step 1 : need retrieve access db's data sql server database.i have done using ssms's import wizard tool.i have given database name legacydata
step 2 : need insert legacy data new sql server database called appdata
.
note : names of tables , column names different on 2 databases.
as e.g. on legacydata
database has table name homeowner foreclosures
.the mapping table's name of appdata
database properties
.
columns :
homeowner foreclosures
: plid,deeddate,county
properties
: id,deeddate,countyid
note : here county
name
of counties
master table , countyid
id
of counties
table.i have mapping here also.
counties
: id,name
can tell me how kind of data migration process ?
i think looking for.
use appdata insert properties select h.plid, h.deeddate, c.countyid legacydata.dbo.homeownerforclosure h join legacydata.dbo.counties c on h.county = c.name
Comments
Post a Comment