sequelize-automate icon indicating copy to clipboard operation
sequelize-automate copied to clipboard

Published 20 hours ago • verified publisher icon nodejh

Schema support

Open ajcaterino opened this issue 5 years ago • 7 comments

Can sequelize-automate support multiple schemas? Currently when it comes across a table that is a schema other than DBO it encounters an error stating that the table does not exist.

ajcaterino avatar Feb 08 '20 03:02 ajcaterino

Hi @DoughNutz , Could you please give me some examples of your schemas?

nodejh avatar Feb 16 '20 01:02 nodejh

It is a Microsoft SQL Server database with a single table and Schemas DBO and one called Test. The table belongs to the Test schema. If it is possible to upload or email a zip file (358kb) I'll send you the database.

ajcaterino avatar Feb 16 '20 23:02 ajcaterino

Would be excellent if we can choose an schema like sequelize-auto. download

dogcalas avatar Mar 16 '20 15:03 dogcalas

Plus. My tables are located in different schemes and this does not work. EXEC sys.sp_helpindex @objname = N'[docs]' <- Error!!! EXEC sys.sp_helpindex @objname = N'[sh1].[docs]' <- Correct!!!

dosikru avatar May 06 '20 03:05 dosikru

Thanks all, I will fix these issues this month.

nodejh avatar May 06 '20 05:05 nodejh

https://github.com/sequelize/sequelize/issues/11948

osmanraifgunes avatar May 27 '20 14:05 osmanraifgunes

Any news?

dosikru avatar Jul 02 '20 10:07 dosikru