Very Computer

by **Carte** » Wed, 09 Jul 1997 04:00:00

Ok I am having a little bit of a problem here, I have a database that is
currently in access 2.0. I want to move it into Sybase SQL server, what
is the best way to do this? I have heard that I should export that
database to a text file and use th BCP program to move it in, someone
else said to export the tables through a ODBC connection, and someone
else told me to get the upsizing wizard from microsoft for access 97 and
it should work (By the way I can not get it to work, I think it has
something to do with the fact that it was made for Microsoft SQL...But
it is only a guess) So if anyone could help me I would appreciate it.

Shane

by **Shannon W. Mile** » Sun, 13 Jul 1997 04:00:00

> Ok I am having a little bit of a problem here, I have a database that is
> currently in access 2.0. I want to move it into Sybase SQL server, what
> is the best way to do this? I have heard that I should export that
> database to a text file and use th BCP program to move it in, someone
> else said to export the tables through a ODBC connection, and someone
> else told me to get the upsizing wizard from microsoft for access 97 and
> it should work (By the way I can not get it to work, I think it has
> something to do with the fact that it was made for Microsoft SQL...But
> it is only a guess) So if anyone could help me I would appreciate it.

> Shane

OK, I tried the nice way, now to repeat what I told you in my e-mail
(which you seem to have quoted quite nicely). Easiest way is to BCP the
files. The ODBC takes forever, makes large tables on the server (take a
look at how large normal text fields are by default in Access). AND the
upsizing wizard *IS* for MS-SQL server and this is not a guess. If this
is simply a matter of not knowing how to use BCP, I can help there. I
have used it and loading a 30MB of data takes about 5 minutes.

Very Computer

The best way to upsize from Access 2.0 to SQL Server

The best way to upsize from Access 2.0 to SQL Server

The best way to upsize from Access 2.0 to SQL Server