AccessToMsSql is a data conversion tool that helps DBA and database programmer to convert Access data to Sql Server database. Main features: 1. Wizard - step by step. 2. Converts from both table and query. 3. Displays progress through time estimation.
Features: AccessToMsSql is a data conversion tool. DBAs and database programmers will be able to convert Access data to Sql Server data. There`s a wizard that takes you step by step through the conversion process. Configuration also is simple, though mouse clicks. The conversion process progress is shown and you know how much is yet to be done. A preview shows exactly what you are going to get. You can convert data from both tables and queries. Unicode is supported so that multilingual data also can be converted easily. The interface has all the necessary controls within easy reach.
The modes of operations available are sessions, source, destination, Data mapping and execution. The data mapping page, for example, will let you set everything needed for the source and destination data to be mapped properly. You get a preview so that there are o problems. You specify if the source is from a table and then specify the specific table which is the source. Destination schema and table name are to be specified. Choose if direct conversions are to be made or via a dump file.fields mapping can be specified. Load rows and skip rows options decide if some rows are to be left out of the conversion process.
Overall: This is a convenient tool for the Access to SQLServer data conversions can be done very easily.