Easiest way to update a database?

[JustATinCan]

I am running a v111, most sources from 111 to 117 all use v83 as the drop table.
Do I have to manually do this ?
Any tips or tricks because this will take a huge amount of hours for me haha.

 

[Z41N]

Hi,

Apart from finding an updated SQL script from a higher version server, your best bet is to input them manually.

I've created a template for you, which outputs the SQL queries for you after you input the values you want (see column named OUTPUT). You can simply copy-paste in bulk the MOB ID and ITEM ID.

At least this way, you don't have to manually edit in every single row - the query is generated for you.

Hope this helps

You must be registered to see links

 

[JustATinCan]

Ah, I see what you did that is nice I will try that.