Move data between different databases easily with Smart INSERT scripts. This software transfers all data types, including IMAGE, BINARY and VARBINARY, from tables and views. Choose to append, replace, or update your data, and use IntelliSense® in WHERE statements for added efficiency.
Not only that, but with insertXpress you can choose how you want the transferred data to be handled; such as appending the transferred data or replacing existing data with it. It can even be used to update existing data matched to the identity field.
InsertXpress provides an efficient solution as it generates a single INSERT script that can contain data from several databases on several servers. The tool generates scripts from tables, views or a combination of both.
Moreover, insertXpress offers a user-friendly interface with its Object Browser feature that helps you easily select the data to include for transfer. This feature expands to show all objects in all databases on all servers, with individual check boxes at each level. When you select a table or view, insertXpress displays the columns in a separate pane, each with its own check box.
You can easily specify the number of rows you want to transfer or use WHERE statements to select records for transfer using the IntelliSense®-like Code Complete feature.
InsertXpress can transfer all data types, including IMAGE, BINARY, and VARBINARY. You can even omit IMAGE data if it is too large. Additionally, you can include identity fields or have the target database automatically generate them.
Your INSERT scripts can transfer data to a named database or to the currently selected database. InsertXpress even shows you the dependencies and scripting order of the data before it generates the script. You can produce a single script file or split it into separate files by server, database or object. You can specify filenames or have insertXpress generate them.
Using insertXpress script viewer, you can edit, save, and run any INSERT script with ease. Overall, insertXpress is a lifesaver for anyone who needs to transfer data between similar tables in different databases.
Version 2.0: N/A