If you want real syncing, you'll need to get the OS X version of Bento 4. It will let you sync up to two devices with the same computer. It's wi-fi syncing on the same network, and both apps (on the computer and iPad) must be running.
If you need something more than that, you'll have to upgrade to FileMaker, and use the FileMaker Go app on the iPad. Not cheap, but a much more powerful solution. Or maybe the HanDBase app will do what you want. Not as pretty, but probably worth looking into.
If you just want to transfer (one time) the basic data fields to the another iPad, mailing the csv file will work. The caveats are that only basic text and number fields transfer, no media (pictures, sound) or logical (checkmark, true/false) fields eckmark, true/false). It creates a new database. You can not use it to sync/add content to an existing one.
At any rate. To export a csv file, select the database then tap the (i) info icon at the top right and choose Email Library. An email will pop up with the attachment. Enter the email address and edit the subject as needed.
When it arrives on the destination iPad, tap and hold the attachment. If Bento 4 is installed it will come up as an Open In options. What you are seeing here is the new iOS 6 Open In... dialog. The iOS 5 one may require a couple extra steps/menus, but you still start by tap-holding the attachment.
