DBConvert for Access & MSSQL 2.0.0

DBConvert for Access & MSSQL is a database migration tool for data
conversion from MS Access database (MDB file) to MS SQL Server and
from MSSQL to Microsoft Access.

You can convert databases simply by configuring several options
through Wizard interface or in command line mode. Ability to organize
application work using command line parameters is supplemented with a
scheduler so you can run the program without user input after
scheduling.

If a direct access to your MSSQL server is denied (insufficient
privileges) you can save your data into a MSSQL Dump file to overcome
such restrictions. The primary function of the MSSQL privilege system
is to authenticate a user connecting from a given host, and to
associate that user with privileges to select, insert, update, and
delete a database. The SELECT, INSERT, UPDATE, and DELETE privileges
allow you to perform operations on rows in existing tables in a
database. The privilege system ensures that all users may perform only
the operations allowed to them. Thus in case you have any privileges
to create or modify a database on the target MSSQL database there is
an opportunity to save your data into a dump file. DBConvert for
Access & MSSQL fixes the contents of the source database into a local
dump file the MSSQL server directly. The destination file will consist
of MSSQL statements to create all the tables and to fill them with the
data. Using this dump file MSSQL server administrator will add data to
your SQL database.

One of the key things of database managing is the ability to filter
data during conversion. Integrated data filters allow users to
retrieve only specific data for converted tables according to defined
filtering criterias (conditions). Filters give you more control on
data migration process.

More Info: http://dbconvert.com/convert-access-to-mssql-pro.php
Download URL: http://dbconvert.com/downloads/dbconvert_access_mssql.zip
Screenshot URL: http://dbconvert.com/images/screenshot/access2mssql_pro-250.jpg
Order Page: http://dbconvert.com/order.php?prodID=102

.

Relevant Pages

  • Re: Using a HEX differential when moving data files.
    ... You can create a full backup of your old database (which is an online ... new server and restore there, and make the new server live. ... > Is it possible to migrate a MSSQL server from one machine to another using ... > Any suggestions on a command line differential utility that will extract ...
    (microsoft.public.sqlserver.server)
  • Re: copying an MS SQL database
    ... If you stop MSSQL Server's services, you're also bringing off line all other databases that reside on the server. ... If however there's not a specific reason, and you're simply trying to make a backup, why don't you use MS SQL's built-in backup capabilities to backup the database? ... You can do so without having to bring SQL Server offline, and you can then backup the resulting "database.bak" file to tape, DVD, offiste, or wherever you wish. ...
    (alt.comp.lang.borland-delphi)
  • MYSQL - DTS - MSSQL help needed Warning novice inside!!
    ... I have a MYSQL server and a MSSQL 2000 server. ... Database name is Membership ...
    (microsoft.public.sqlserver.dts)
  • Access2MSSQL PRO 1.2.0
    ... Access2MSSQL Pro is a database migration tool for data conversion from ... MS Access database to MS SQL Server and from MSSQL to ... privileges) you can save your data into a MSSQL Dump file to overcome ...
    (comp.software.shareware.announce)
  • Re: [PHP] text field truncation with sql server
    ... Does your database driver, whatever it is, which you've told us is not ... PDO, have any kind of limit in the buffer size of query data ... I see mssql in the code, so assume that's it, right?... ... On Thu, July 12, 2007 11:37 pm, Bruce Cowin wrote: ...
    (php.general)