Access >>> Ms Sql

[gwendaal]

is there a perfect way to create a MS SQL 2000 database from an existing MS ACCESS 2003 database

without datas (empty)

or

with datas !!!

?
?

thank you

[Rawhide]

There is no perfect way to create a MS SQL database from an Access database.

[gwendaal]

ok .... and a way ?

[VERESK]

Do you want to move only table properties & datatypes, or aslo you want to move relations, data integrity and convert all querries in procedures? =)

U can move tables thow the ADO or DAO or through the ODBC connectin.
As I remember, there was an import wizard in MSSQL SERVER...and it had an MSACCESS option...

[gwendaal]

of course I want to get the maximum .. relation, foreign keys ....

thank you

[VERESK]

There is no easy way.
If you want to do that automaticly - you'll have to write a datatype convertor DAO<=>ACCESS, else you'll have to do it by hands...

[Rawhide]

Originally posted by gwendaal
ok .... and a way ?

Because the two do not support the same things. For example, if you have a VBA Module in Access, what should you convert it to in SQL Server?

[KnooKie]

there is an upsizing wizard in MS Access to port it over to SQL Server.

How complex is your database ?

[gwendaal]

of course without vb module ...

just tables !!! and relations

my base is half-complex

i must look this wizard then...

thank you

[Rawhide]

There is a big difference in functions as well. For example, in Access, you can use Trim() to trim leading and trailing spaces, but in SQL Server you only have RTrim() and LTRim(). And the wizard doesn't automatically convert Trim() to RTrim(LTrim()) for you.