Calling Server Experts

[jdoran]

I've heard that Visual Studio can compare two databases and generate a script to synchronize them. Keep a copy of the release database and diff them as needed.

[Drakiyth]

One thing that I think new devs should also be aware of is deletion of items for a new item. Whatever you do, don't
delete something in the database and make it into something else (same ID) that is more powerful or quest related.

Here is why:

When you remove an item from the database and replace it with something else you have to remember that there is a
possible chance that item was connected to an NPC loot table or even a merchant. Some devs will do this on accident and
all the sudden find out a uber quest item they created could be bought from the local merchant for a buck and change.

If you do change something already made, make sure the loot table and merchant tables don't have that item!


Best of luck with your project.

[chrsschb]

Originally Posted by jdoran

I've heard that Visual Studio can compare two databases and generate a script to synchronize them. Keep a copy of the release database and diff them as needed.

Would be an awesome thing to have a walkthrough for.

[vsab]

Originally Posted by chrsschb

Would be an awesome thing to have a walkthrough for.

All the Visual Studio tooling is based on M$ SQL Server. I also tried to get EF to work with MariaDb but it's a fight and not really worth it.