coolsel

coolsel official version official version is a compilation software. The latest version of coolsel contains Asp There are two versions of SQL script generation and editing software, Exe and Exe, which can be directly imported into SQL server. Coolsel was tested with multiple currently popular Access entire site and forum databases (the largest 80M database was tested). The Asp version does not support direct import into SQL server, only Support script writing, Exe Versions can be imported directly into SQLserver.

coolsel function introduction

Generate the upgrading SQL script, save it as a *.sql file, and load it into the query analyzer of SQL2000 for execution

Generate the upgrade ASP script, so that you can use the script and the corresponding MDB database to upload to the server for online upgrade

Directly execute Access data import to SQL2000 server (table structure and data)

Fix the problem that the bit type cannot be converted normally in the default value

The default value of time is increased by converting time() date() to getdate()

The Vba function of the view has not been processed. A later version will launch support for T-SQL conversion corresponding to SQL server.

Supports input database creation and login creation

​​Support Access to directly import SQL

This adds the function of directly importing SQL server

Add import options All tables Index Import according to Unicode encoding, whether to generate import data, etc.

                              Fixed the problem of surrounding single and double quotation marks in the default value processing. Access’s default value is not surrounded by single quotation marks. Some errors think that, for example, the null character is set to ''

It is wrong for access and is not equivalent to ('') in SQLserver. The import program automatically corrects this.

I found a lot of forums and the entire station database for testing, and they were successfully imported

The program generates the upgrade script (table structure and data) from Access2000 MDB database to SQL server

Including default, indexed primary key, foreign key view and tables in the entire MDB library

coolsel installation steps

​ 1. Download the coolsel official version installation package from Huajun Software Park

​​ 2. After downloading, unzip the compressed package into a folder named after this software

3. Open the folder and double-click the "exe" program

​ 4.coolsel is a green software and can be used without installation.

coolsel update log

​​ 1.Fix some bugs

​​ 2. Optimized some functions