Folks, It took a while because I was busy with other things but now I have to come back to this topic.
> On 28 Feb 2019, at 10:19, René Bock <b...@salient-doremus.de> wrote: > > Hi, > > unless you need to use ERXMigrations for schema creation, you may simply use > the com.webobjects.jdbcadaptor.MicrosoftPlugIn. No migrations required. How would I use the plug-in? Possibly silly question, but when I create an EOModel I cannot specify the plug-in to use (MSSQL is not in the popup list) and therefore I have no prototypes available. I might be missing something here simply because it's possibly too trivial and everything has always worked out of the box so far. Thanks for some hand holding ---markus--- > > If you need ERXMigrations, things become bit hairy, since Microsoft did > some strange sql extensions: > > utf-8 Support: varchar don't support UTF-8 characters. You have to use > nvarchar, ntext, columns if you need to store utf-8 characters > text-bolb: text (and ntext) are deprecated. Microsoft encourage to use > varchar(MAX), which is not really standard sql :-( At least I wasn't able > varchar(max) text blobs using the default EOSchemaGeneration mechanism. > > Chuck once did write an (experimental) ERXMicrosoftPlugIn, to address > migration-support. Unfortunately, didn't find it's way into WOnder. > Fortunately I got a copy of chucks plugin and added the nvarchar/ntext > migration support. But my implementation required some changes in > ERPrototypes, which are not backward compatible... > > > >> Am 27.02.2019 um 10:40 schrieb Markus Ruggiero <mailingli...@kataputt.com >> <mailto:mailingli...@kataputt.com>>: >> >> We are about to get a new project but the customer requires the application >> to run against an existing Microsoft SQL Server (version not yet known). >> When I create a new EOModel there is no selection for an MS SQL Server >> plug-in. No support in Wonder for Microsoft? >> >> Does anyone have experience running a Wonder App against a Microssoft >> database? >> >> Please help and advise >> ---markus--- >> >> _______________________________________________ >> Do not post admin requests to the list. They will be ignored. >> Webobjects-dev mailing list (Webobjects-dev@lists.apple.com >> <mailto:Webobjects-dev@lists.apple.com>) >> Help/Unsubscribe/Update your Subscription: >> https://lists.apple.com/mailman/options/webobjects-dev/bock%40salient-doremus.de >> >> <https://lists.apple.com/mailman/options/webobjects-dev/bock%40salient-doremus.de> >> >> This email sent to b...@salient-doremus.de > > Mit freundlichen Grüßen > > René Bock > > -- > Telefon: +49 69 650096 18 > > salient GmbH, Lindleystraße 12, 60314 Frankfurt > Telefon Zentrale: 069 / 65 00 96 - 0 | www.salient-doremus.de > <http://www.salient-doremus.de/>
_______________________________________________ Do not post admin requests to the list. They will be ignored. Webobjects-dev mailing list (Webobjects-dev@lists.apple.com) Help/Unsubscribe/Update your Subscription: https://lists.apple.com/mailman/options/webobjects-dev/archive%40mail-archive.com This email sent to arch...@mail-archive.com