Hi,

unless you need to use ERXMigrations for schema creation, you may simply use 
the com.webobjects.jdbcadaptor.MicrosoftPlugIn.

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

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

Reply via email to