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

Popular posts from this blog

wordpress - (T_ENDFOREACH) php error -

Export Excel workseet into txt file using vba - (text and numbers with formulas) -

Using django-mptt to get only the categories that have items -