Rank: Newbie
Joined: 2/10/2021 Posts: 8 Location: Canada
|
Hello, I have mapping, implemented to import XML files into MS Access database. Now I need to do the same import into MS SQL database. Table names and column names in both databases are identical. Is it possible to just change destination database, and re-use existing mapping? I have tried, but "old" Access tables keep showing with red question marks.. Thank you
|
Rank: Advanced Member
Joined: 2/27/2009 Posts: 558
|
All you have to do is drag the root connection from the old Access table to the SQL Server one (that is, from Access' schema-less "example" in the attached screenshot to SQL Server's "dbo.example"). MapForce will prompt you to decide if you want also to move descendant connections as shown in the screenshot. Click "Include Descendant Connections" and MapForce will move them all in one go. This is described in the documentation under, Moving Connections and Child Connections. K101 attached the following image(s):
|
Rank: Newbie
Joined: 2/10/2021 Posts: 8 Location: Canada
|
Thank you!
|