Managing pictures and videos between my iPhone and iPad
Apple wants you to use their PhotoStream or do manual syncing all the time. From my personal experience it's impossible to manage some parts in PhotoStream and some others outside. I'm sure it's possible to do some crazy scripting, symlinking and syncing. But hey... that's not the reason why we use Apple products in favor to the more open Android ones, right?

I ended up re-creating my Aperture and iPhoto libraries and a big upload session to PhotoStream. Works fine so far.