Originally Posted by meister
A Bolgna si mangia bene!
Bologna is such an amazing place, probably the most habitable "big" city in Italy. Being used to Venice, you will love the scale and the fact that it is a very walkable city.
I don't know how long you'll be there, but for things to see I would recommend Santo Stefano (a must-see, plus there is beautiful square as well, which used to house a nice little flea market, maybe still there); San Petronio (mainly for the sun-dial clock inscribed in the floor, and the chapel); the walk along the porticoes up to the Santuario San Luca is great (long walk though); the National Picture Gallery (Pinacoteca Nazionale di Bologna, another must-see); Museo Morandi; Modern Art Museum (MAMBO); there is also the Ducati Museum and the Lamborghini Museum if that kind of thing is of interest. The Botanical Gardens are beautiful.
Simoni and Salumeria Bruno are good delis. Enoteca Italiana is great. For restaurants, forget Diana. Da Cesari is good but not inexpensive. La Locanda del Castello is also good; Osteria dell Orsa, Trattoria La Montonara, Le Mura Osteria were good smaller places. I can't remember the names of some others...there are so many good restaurants and trattorias there.
As far as stores go, there are many nice shops, and again it is great to just walk along the shopping streets, but one particular store is Antica Aguzzeria del Cavallo (along Drapperie I think); it is an amazing store for cutlery, hunting things, etc. I bought some amazing small brass bird whistles there years ago, just because they were such beautiful objects. It's worth going in to see all the amazing and unique stuff.