C1 Community

Hi Andrey, hi everybody :-)

I am upgrading to SQL Server (2005 Express) and i would like to know if just changing the connection in the Schema Designer is enough, or should i change something more.

I have the db conversion done, changed the connection and tested a few datasets filling them via the schema desiner with no problem, but as the schema is rather large, it is difficult to check everything from there (i will do that later debuging) or should i?

I am aware about some of the sql syntax differences (i.e. for for DateTime and Boolean fields) and i will manage on this subject wherever i use server side filtering in code.

So, is there something allready known that i should know before i learn it the hard way? Are field types updated automatically or should i make any changes?

Any knowledge on the subject will be much appreciated.

 Thnx in advance,

Takis

Hi Takis,

I tried to upgrade from MS Access to MS SQL Server. I have changed
the connection string (switched from "MS Jet OLE DB Provider" to
"MS OLE DB Provider for SQL Server"). It was enought. I don't see
any problem after this change except the common problems that are
specific to any OLE DB connection.

> Are field types updated automatically or should i make any changes?

The field types will not be updated automatically. There is no need to
update them because you are still using an OLE DB connection.

Though, the native SQL Server data provider works better than OLE DB.
When migrating from MS Access to MS SQL Server I would rather
recreate the whole data schema from scratch using SqlServer connection
type instead of OLE DB. It is difficult to upgrade an existent schema
because all native field types are different for SqlServer connection.

Regards,

-Andrey