search

wise-coders / dbschema

DbSchema Database Designer
https://dbschema.com
67 stars 3 forks source link

Procedures and Functions listed twice, in wrong folders. #14

Closed dredev11 closed 4 years ago

dredev11 commented 4 years ago

DbSchema version: 8.2.7 build 200130 Operating system: Windows 10 Pro (10.0.17134 build 17134) Used database: SQL Server 2016 Developer Edition

The steps to reproduce this issue: 1) Start new project 2) Connect To Database 3) Using the Database Connection Dialog: connect to an existing database (using Native Driver - Database Authentication) 4) Check a schema and all of the objects inside (Tables, Views, Procedures, Functions, ...) 5) After the procedure is completed: in the Project view, look at the folders Procedures and Functions. They containt the same quantity of objects, i.e. all the user functions and procedures in both of the folders.

I was expecting the User Defined Functions to be under the Functions folder and the stored procedures under the Procedures folder, separately.

Procedures and Functions

wise-coders commented 4 years ago

Could you please try to delete the folder .DbSchema from C:\Users\ ? This will delete all cached settings. Connecting to SQLServer you have to choose another database and then again SQLServer, so the driver is downloaded again. Than try again to reverse engineer the schema. Does this look better ? If the issue still persist we will test in detail. We are using the queries configured in Project / Settings / Reverse engineer to grab the procedures and functions. Eventually you can execute them in the SQL Editor.

dredev11 commented 4 years ago

Could you please try to delete the folder .DbSchema from C:\Users ? This will delete all cached settings. Connecting to SQLServer you have to choose another database and then again SQLServer, so the driver is downloaded again. Than try again to reverse engineer the schema. Does this look better ? If the issue still persist we will test in detail. We are using the queries configured in Project / Settings / Reverse engineer to grab the procedures and functions. Eventually you can execute them in the SQL Editor.

Sorry, I closed the issue by accident.

I tried to follow the instructions, but the result is not changing. I also tried to force manually the donload of the drivers, still same result. download drivers

I tried to execute the queries under Project/Settings/Reverse Engineering and they seems to work fine: the one for Procedure retrieves the name of just the stored procedures, the one for Functions the name of just the user defined functions. scripts

dredev11 commented 4 years ago

I also tried to 1) uninstall dbschema 2) delete the folder .DbSchema from C:\Users\ 3) reboot 4) re-install but the issue still persists. When opening dbschema the first time after re-installing it, I found my Database Aliases already filled in, so I'm wondering if I should delete other files/folders too.

Thank you.

wise-coders commented 4 years ago

Issue is fixed in version 8.2.8, currently available on website. Please reopen the issue if this does not work as expected.