Copy Schema and Clone Table For Sql Server Software for Windows

SQLDBCompare
$129 - 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!

---

---

SQL Examiner Suite 2008
$299.95 - TulaSoft, LLC

SQL Examiner Suite 2008 is a quick and easy-to-use software solution that enables you to compare and synchronize both schema and data. It covers all your SQL database comparison and synchronization needs, and fulfills any task on merging databases with just several clicks of a mouse.

SQL Examiner Suite 2008 is a complete database comparison solution. It includes SQL Examiner 2008 and SQL Data Examiner 2008, so in one program product you get two comprehensive tools that complement one another, and thus receive an opportunity to use the advantages of each of them.

The suite provides support for all main innovations of SQL Server 2008, so now you can work with all SQL Server version from 7.0 to 2008, and run cross-version comparison, when one of the compared databases is on SQL Server 2005, for example, and the other is on SQL Server 2005.

SQL Examiner Suite 2008 supports Oracle and MS Access as well, and allows cross-platform data comparison. Besides, it is able to use different comparison sources, and equally well runs on a backup copy, a detached database or database snapshots. With the suite you can compare all data objects, including tables, views and SQL?query. And the list of the schema objects it compares includes tables, stored procedures, views, user-defined functions, XML schema collections, CLR objects, database triggers, etc.

Due to its flexibility you can be as involved in the comparison process as you want. You can choose step-by-step or automatic synchronization, so the built-in Command Line Comparison and Synchronization Tool allows you to automatically perform any actions available in the GUI. But even if you choose the automatic ?one-click? synchronization, you can undo it any moment to adjust the settings.

SQL Examiner Suite 2008 is a solution that works for the profit of your business. Now you can forget about routine manual work and focus on design and development, as the suite will handle all the tedious manual work itself.

---

---

XMLSpear
$0 - DonkeyDevelopment

XMLSpear is a free XML editor with a great real-time validation feature.
It is easy to use, built in Java and available for all platforms.

XMLSpear is great for users that just want to edit or check XML files without deep knowledge of the XML syntax. The XML is displayed in three different views:

The treetable is great to see the structure of the xml file. Edit your xml files tag-free in this view and don't worry about typing reserved xml characters because it is all handled for you. You can insert and delete nodes, and even build a whole document from scratch. It is the most convenient view for correcting and editing xml. This view makes XMLSpear different form many other XML tools.

The element view is especially usefull if your element has many attributes.

The source view is great for correcting unwellformed xml, doing finds-replaces or copy-and-paste. You can always escape to this view to do advanced things that are not supported in the other views.

You can also validate and edit XML Schema (xsd) files.

Mac OS users can open and edit their plist files, even when they are in binary format.
XMLSpear is packaged with a MQSeries plugin for browing queues and putting messages, so you can even test your MQ based services.

You can extend the fuctionality by writing your own plugins written in Java, which is really very simple.
A sample plugin is now included in the download package !!

---

DTM Data Modeler
$179 - DTM soft

DTM Data Modeler is a CASE tool for database developers that supports both forward and reverse engineering. It is an easy-to-use tool allowing you to work both with logical and physical data models in the form of an entity-relationship (IDEF1X notation) diagram. The product is intended for database architects and developers and works with data sources via the ODBC, OLE DB, IDAPI or Oracle Call Interface, which means compatibility with all modern DBMS. Along with basic model properties (sets of entities and relationships between them), the program allows you to create indexes and triggers on the physical level corresponding to the tables of the database that is modeled. The foreign key migration feature makes schema development easier and more visual and also reduces the probability of errors in the integrity of the model. The program can create database schema objects directly in the database as well as to create SQL scripts corresponding to the model and taking into account the settings specified by the user.
The built-in scale and print tools of the model allow you to get a visual representation of the model in the hard copy form for presenting or discussing it. Powerful reverse-engineering tools make it considerably easier to work with existing databases and also provide easy migration from other tools. Both full and selective generation of model objects is available to the user, which makes the product more flexible.

---

blueshell Data Guy
$29 - HvB Computer Engineering

The blueshell Data Guy is an ADO-based editor for virtually all types of databases. This program supports Jet (Access and ISAMs like dBase, Paradox etc.), Oracle, SQL Server, MySQL, Sybase and Advantage DB. Additionally you can use other OLEDB or ODBC providers.

All connections, schemas, table types and tables are shown using a tree view. You can open a new connection and tables of this connection with a few mouse clicks. You can watch all properties of your opened connections and of the recordsets using bAsk - the "blueshell ADO Survey Kit" included in this program.

Enjoy the magic of connectivity! Exchange tables between your Desktop applications like Word, Excel, Outlook, Frontpage etc., your database files (.mdb, .dbf, .xls, .db etc.) and your client-server databases like Oracle, MS SQL Server etc. Nearly everything that can contain a table can be the source or the destination! Import, Export, Copy, Paste, Drag and Drop as you like!

The "blueshell Data Guy" uses the atb control from "blueshell Active Tables". A runtime version of this great ActiveX control is included.

---

Migrate-Data (data migration tool)
$0 - Akcess

Migrate-Data is a pure java and an extremely powerful enterprise data migration tool. It supports open source and commercial databases.

With Migrate-Data the user can easily extract, transform, load and integrate data from any-to-any databases. In addition the user can also perform customized data extraction from source and create customized target objects.

FEATURES

1.Migrates data to target database having same or different schema from the source database

2.Generates ?CREATE TABLE? script for target table by having the selected fields from one or more tables with modified properties.

3.Incorporates a query builder that helps to create SQL SELECT statement by having selected fields from one or more tables, with data filtering conditions

4.Facility for parsing SQL SELECT statement and checking syntax

5.Option for adding a field for generating data of type sequence or identity, along with the selected field/s from the source table/s

6.Facilitates for changing target table name, field name, field type and size while extracting data from one or more tables in the source database, flat file and Excel sheet

7.Facility to execute SQL SELECT statement that is stored in a file for extracting data from the source database

8.Facility to paste SQL SELECT statement by copying that from out side sources for extracting data from the source database

9.Incorporates Driver manager that helps to instantiate a JDBC driver dynamically at run time

10.Generates DDL (Data definition language) script
11.Provides syntax editor for viewing, editing and saving generated DDL script for the target database

12.Provides syntax editor for viewing, editing and saving generated CREATE TABLE statement for the target table, from the selected tables and declared constraints.


Data Source

Oracle, SQL Server, DB2 UDB ,MySql, PostgreSql, Ingres, Informix, Mimer SQL, MaxDB, MS Access, Flat File, Excel file

---