+ 3

How to migrate row to another database in SQL

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

17th Apr 2018, 10:57 PM
Antony O. Onyango
Antony O. Onyango - avatar
3 odpowiedzi
+ 4
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 ; )
11th May 2018, 8:58 AM
Ipang
+ 3
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 : )
11th May 2018, 9:08 AM
Ipang
+ 1
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
11th May 2018, 9:02 AM
Antony O. Onyango
Antony O. Onyango - avatar