the autoupdate method of the bdpdataadapter is also enhanced and is now capable of resolving multi-table updates and better error handling.
data migration
a special bdp component called bdpcopytable supports data migration, and enables you to copy tables including data from one bdp supported database to another.
typed datasets (.net)
typed datasets now produce code that compile to standalone .net assemblies. typed datasets also support datasets from web services. the project manager offers context menus to start the relation and table collection editors for a dataset, so you can modify a typed dataset more conveniently.
database explorer enhancements
the database explorer, for bdp data providers, has been enhanced in several areas as well. it now supports easy data migration from one bdp data provider to another, with a feature that allows you to copy a table from one bdp data provider, and pasting the table in another bdp data provider. this will copy and reconstruct the table meta data as well as the data to the target database even if the source and target databases are of completely different vendors; from oracle to mssql for example. this corresponds to the behaviour of the bdpcopytable component.
the data explorer offers additional meta data capabilities, and allows you to view and modify the database schema directly from the data explorer. you can create new tables, alter tables or drop existing tables.
it's also possible to drag a stored procedure directly from the data explorer to a forms designer, which will create an instance of the bdpconnection (when needed) and bdpcommand, automatically assigns the stored procedure to the bdpcommand, and populate the parameters for the stored procedure.
vcl and vcl.net database support
delphi 2005 contains database support for vcl and vcl for .net applications in the form of bde, dbexpress and dbgo for ado as well as interbase express (ibx). these data access technologies exist for both vcl and vcl for .net projects, and offer a seamless migration path from win32 to .net.
dbgo for ado
when building vcl for .net applications, delphi 2005 now supports dbgo for ado for both win32 and .net, which also makes migration of win32 dbgo for ado applications to the .net framework possible. the dbgo for ado components require mdac 2.8.
dbexpress
the dbexpress components have been extended by a tsimpledataset for .net, better performance for tsqlstoredproc, and meta data improvements.
