SQLDBCompare
By Best SoftTool, Inc.
What is SQLDBCompare? SQLDBCompare is the powerful database schema/data comparison and synchronization tool for SQL Server database development projects. SQLDBCompare integrates with SQL Server, providing an effective and effortless database schema comparison for individuals and project teams to compare the SQL Server databases on either the same server or different servers. It also provides the functionality for developers to synchronize the SQL Server objects from one database to another. With SQLDBCompare, users can compare database structure/schema/table records over database objects (tables, stored procedures, user defined functions, views, triggers, indexes/keys, and constraints) in two databases. User can view the results at a high-level, or drill down to the fine grains of every detail for each difference. The users can synchronize each database object by copying the object (structure) from one database to another. It supports both SQL Server 2000 and SQL Server 2005. Who needs SQLDBCompare? Any project team or DBA''s managing multiple copies of the same database on SQL Server. If you have various database environments such as development, test, staging, and production, or distributed SQL Server databases where schema/code updates to each database can occur at a different time, SQLDBCompare is the right tool that you have been looking for!
Infralution Virtual Data Objects
By Infralution
Do you miss the simplicity of programming with ADO under Visual Basic 6? Are you tired of spending precious time creating and configuring ADO.NET DataAdapter, DataSet and Connection classes each time you make a change to your database? Is ADO.NETs disconnected model making your simple desktop application seem like a major enterprise programming task? Infralution''s Virtual Data Objects (VDO) may be the solution you have been waiting for. We give you back the simplicity and flexibility of the traditional ADODB programming model while allowing you to still take advantage of .NETs powerful data binding model. VDO provides classes that wrap the standard ADODB Connection and Recordset classes allowing them to be used as fully featured data sources for .NET controls such DataGrid, ListBox, ComboBox and of course Infralutions own range of powerful controls. It only takes two lines of code to populate a DataGrid - with no other design time configuration needed. If you decide to change your database schema there are no coding changes necessary!
DataForms.Net with Source
By MediaCom
DataForms.Net allow developers to rapidly create database applications on MS SQL Server or other RDBMS. Just point DataForms.Net to any table in your database and DataForms.Net will get underlying schema and dynamically create forms to add, edit, delete, sort, filter and print data. No more tedious SQL syntax to JOIN multiple tables, DataForms.Net automatically create joins on multiple tables according to relations beetwen them. Data input is automatically validated according to column properties such as datatype, maxlength, foreign key constraints etc. Aditionally you can use your own custom data validation functions. Data displayed in DataGrid can now be easily printed taking in consideration how you sorted it and column width. Your applications users can configure position and size of controls at runtime. If database schema changes no recompile is required because DataForms.Net works dynamically. Don''t write that repetitive code anymore just point DataForms.Net to table you want and concetrate your development time on other tasks. A lot of code in your applications don''t have to be written with DataForms.Net. You can even write whole application with it. Functionality: Dynamicaly creates forms to add, edit, delete, sort and print data. Dynamic ForeignKey lookup with multicolumn ComboBox. Automatic input validation according to field data type or custom validation functions. Computed columns are possible which will be automatically calculated from other columns values. Prints DataGrid sorted on any column with column widths changeable at runtime. From each DataForm you can popup new DataForms to add new records to related tables. Each DataForm is open modaly and you can popup indefinetly many DataForms one over another. All text is fully localisable. Look and Feel: Controls size and position can be changed even at runtime. Move beetwen controls using "Tab" or "Enter" key. Control in focus changes color.
Sync For SQLServer
By SleepyAnt Software
Sync For SQLServer is designed for software developers or database administrators who are working with the Microsoft SQL Server database. It compares two SQL Server databases and determines the differences between them. It generates a SQL change script to convert the database architecture with its tables, relationships, stored procedures, functions, ... AND DATA into the desired target database. The existing data in the target database remains completely intact. This is an invaluable tool if you are going through rapid development and release cycles that require extensive modifications to the architecture of the database. You can save hours of work to keep your databases in synch. Sync For SQLServer has a visual and easy-to-use interface both at the stage of selecting the databases to be compared and to view the comparison results. The software has a lot of options for comparing all relevant objects. The resulting change script can be edited with support of SQL syntax highlighting. One of Sync For SQLServer unique features include the data migration from the source database to the destination database. Other tools don''t offer this feature in one product, which is integrated with Sync For SQLServer. You can migrate the data in a lot of ways to get your data to the destination database where it is exactly wanted. Sync For SQLServer is based on the Microsoft .NET framework. The very easy to use and intuitive graphical user interface applies the MS Visual Studio 2005 style.
Teroid Data Source Browser
By Teroid Software Limited
Teroid Data Source Browser is a .NET control displaying a data source''s schema in a tree, list box or list view. The data source can be a connection string, an OleDbConnection object, a DataSet object or a DataTable object, and the DataMember property can be set to show the columns of a specific table or view. Events are raised when the user selects a table, view or column, the names of which can be retrieved using the relevant properties.
DB Visual ARCHITECT for Windows
By Visual Paradigm International Ltd.
DB Visual ARCHITECT, a sophisticated Object to Relational mapping designer and code generator to you. DB-VA generate real executable persistence code, persistence layer and database (DDL or direct execute to the database). You can focus on developing business logic and user interface without care about the database issue. The persistence layer of the DB-VA is build on top of the most popular persistence layer, Hibernate. There is no vendor lock on when adopting DB-VA. All generated code can run on all popular relational database (e.g. MySQL, Oralce, SQL Server, DB2) and Application Server (e.g. JBoss, WebLogic Server ....). To know more about how DB-VA can help, please visit the Java ORM resource page at http://resource.visual-paradigm.com/orm.html#java_orm You can use DB-VA to: +Design your object model by UML Class Diagram +Design your database by Entity Relational Database (ERD) +Generate Class Diagram from ERD +Generate ERD from Class Diagram +Generate POJO, DAO, Factory, Static method style persistence Java code +Generate Database Schema (DDL) +Create table directly from dialog box +Shape editor +Fast project loading and saving speed +Modeling collaboratively with CVS and Subversion (New Feature) +Interoperability with UML2 model (UML2.x metamodel for eclipse platform) through XMI (New Feature) and more..... DB-VA home page: http://www.visual-paradigm.com/product/dbva/ DB-VA Quick Tour: http://www.visual-paradigm.com/product/dbva/dbvaquicktour.jsp Programmer''s Guide for Java: http://www.visual-paradigm.com/product/dbva/dbvajavaguide.jsp Screen shot: http://www.visual-paradigm.com/product/dbva/dbvascreenshots.jsp