I have changed all my tanks from gravel to sand (happened to use Quikrete Play Sand which is ideal and available in NA) about 8-9 years ago now. Wished I had done it much earlier, and never looked back. But, changing the substrate is a major upheaval and should not be done with fish left in the tank. I know, some do it, but that does not remove the risks and we have had members here who lost fish by leaving them inn. Someone mentioned anaerobic spots in the substrate--this is applicable to any substrate depending upon depth but also decor like chunks of wood, rock, or ornaments left in the same spot and then disturbed.
I always use a spare tank with some sand in the bottom, held in the cupboard for such work, it does not need to be as large as the display tank. Fill it with water syphoned from near the top of the display tank. Move the filter and heater over undisturbed (if much smaller a tank, be sure the heater will not overheat the smaller space). Move over some of the decor to provide shelter for the fish. Plants can be left floating. This provides plenty of time to do the job, and it means you can net the fish back in the morning rather than evening, which allows them to settle much better. Have a cover on the tank, it is amazing how fish will often jump, even cories will be on the floor. The completed display tank can be filled with fresh water, dechlorinated obviously, provided the parameters (GH, pH and temp) are reasonably the same to those of the temp tank.
To clear up an earlier point...the substrate once established is the prime bed for bacteria in the aquarium. More important than the filter, which you can (or should be able to) do without, other than for water circulation--but not the substrate. Not just nitrifying bacteria, but even more important bacteria, aerobic and anaerobic, both are essential for a healthy system. Anaerobic areas likely occur under wood, rock, etc, so leave them alone during water changes if you do want to vacuum over the open areas of substrate. Never dig under these areas. The fortunate thing is that the substrate bacteria bed will re-establish, and its temporary loss will not harm the fish. Another note, with live plants you should have no nitrifying issues anyway; plants can take up a surprising amount of ammonia/ammonium, and they outcompete the bacteria in the filter doing so in most tanks.