#11149: Comapare option is not disabled and Create Script is generated for same in MS Excel db.

VikramPacharne(*) reported 2013-12-23T12:52:20Z · last modified 2013-12-30T20:36:34Z

Comapare option is not disabled and Create Script is generated for same in MS Excel db.

Dev	JennyNishimura
QA	tariqrahiman

Priority	Low
Complexity	Unknown

Component	DB - Excel
Version	15.0

Aqua Data Studio 15.0.0-dev-56

Build #: 35304

Built on: 2013-Dec-20 07:02:58 AM

O.S. : Windows 8.1(64 bit)

Database: MS Excel

Steps to Reproduce :

1] Create one table in D: or anywhere in hard Disk(Here I have created table "table_ecxel1") and create two or more Excel file in same folder(Here I have created three file 'emp','excel_file','new_schema').

2] In Regiser Server of MS Excel window, Add path of Folder in Directories box of Location pane.

3] Save the connection.

4] Go to database tree node of MS Excel in Schema browser window.

5] Connect and Expand tree node of MS Excel.

6] Expand Databases tree node.

7] Select and right click on Database(i.e. table_ecxel1), and Expand it.

8] Select multiple schemas (i.e. excel_file and new_schema), Right click on it and Select 'Compare' option.

9] Compare window opens with CREATE SCHEMA script.

Whereas MS Excel Database only support Select statement.

1 attachment

compare.png

2013-12-23T12:52:20Z

88 KB

All Comments (3) Change History

JennyNishimura 2013-12-23T21:54:56Z

The Compare option is now disabled for the Database, Schema, and Table nodes of Excel.

VikramPacharne(*) 2013-12-26T08:39:46Z

Verified in ADS 15.0.0-dev-58

tariqrahiman 2013-12-30T20:36:34Z

Verified in 15.0.0-dev-59

Search Tips

Aqua Data Studio / nhilam

Comapare option is not disabled and Create Script is generated for same in MS Excel db.

1 attachment

Issue #11149

Completion

Search Tips

Aqua Data Studio / nhilam

Title

Comapare option is not disabled and Create Script is generated for same in MS Excel db.

1 attachment

Issue #11149

Completion