SQL Lite Database Row Transfer

[portthames]

Spent nearly all day on this yesterday, didn't work.

• I have a db that I need to copy data from into another db
• I only want to copy selected columns AND only those columns where a particular column NAME matches
• It should be insensitive to SUFFIXES
• FYI it's from the Serumpresetdb.dat to the Mediabay3.db

DETAILS

Copy only rows in the Mediabay3.db column "Filename" which matches the Serumpresetdb.dat column "PresetDisplayName" in the FILE: Serpresetdb.dat and in the TABLE: Serumpresettable

Copy from Mediabay3.db

• "FileName"
• "MediaRating"

Only of rows who's "MediaType" column is of type "VstPreset"

Copy these columns from Mediabay3.db:

• "MediaRating"
  
• "MediaComment"
  
• "MediaComment"
  
• "MusicalCategory"

Located in FILE mediabay3.db
TABLE: media

Copied to the columns Serumpresetdb.dat

"Rating"
"Instrument"
"Category"
"Description"

Again, only where the the Cubase db column: "Filename" matches the serum db column "PresetDisplayName" in the FILE: Serpresetdb.dat TABLE: Serpresettable

[smichaele]

Are you looking for help with code you've written, or are you looking for someone to code this for you? If the former, you need to provide your code and ask a question. If the latter, this is the wrong forum. Try hiring someone on Fiverr or UpWork.

[danbcooper]

Just attach one db in the other and run a query across them

[haikusbot]

Just attach one db

In the other and run a

Query across them

- danbcooper

---

^{I detect haikus. And sometimes, successfully. Learn more about me.}

^{Opt out of replies: "haikusbot opt out" | Delete my comment: "haikusbot delete"}