I've been building apps using the form wizards, building filtered indexes, using seek/ locate, creating combo boxes wich represent fields in some table, giving the user the oportunity of skip from one record to the next, prior, and so on.

How are these features affected if I migrate to a Sql server database?. I've been told that no filtered indexes are posible, and that I must start by thinking on sets of records, use of views, stored procedures......

How does an app work when built to use sqlServer or Oracle databases?

Tks