How to migrate row to another database in SQL

Question

i am working on an app that queues tasks and i would like to impliment a handler which moves a task to a different category through database migration... anyone with knowledge on a better alternative apart from performing an insert+delete query? i want to avoid errors as much as possible

Answer 1

Antony Otieno Onyango,
I'm a little reluctant in responding to your question here, I'm afraid I might misunderstood your actual point in the question, anyways, correct me if so...
I'm thinking, if you only need to change a particular task's category perhaps you can instead use a 'category' field in your tasks table and have that field value change as per your preference, I guess it's more simple compared to moving records between databases.
Sorry if my response was not what you meant to find, it was just an idea crossed my mind ; )

Answer 2

Yes Antony Otieno Onyango, that would also be what I have in mind, just adjust the query to filter on the selected category, best of luck with that app : )

Answer 3

you are actually making sense.. i get your p.o.v and yes that seems simpler!!
then i like adjust my query to filter based on the category value? right... that seems like a better way to go around it Ipang