Access 2000 to SQL server

Hi everyones,
Is there an 'easy' way to migrate an Access 2000 db to SQL Server 2000
or 2005?
thank you
serge
Yes, there is a utility for SQL Server 2000, that will import all your
tables and data for you. I forget what it is called but it comes with
enterprise manager. I am pretty sure your views will not be imported
though as they use different languages.
|||menu "Tools->Database Utilities->Upszing Wizard...". Note, after running the
wizard, there may be still some manual modifications is required to the
generated SQL Server DB, depending on how complicated your Access DB is.
"Serge Myrand" <info@.softdelirium.qc.ca> wrote in message
news:43DD164D.420B97F4@.softdelirium.qc.ca...
> Hi everyones,
> Is there an 'easy' way to migrate an Access 2000 db to SQL Server 2000
> or 2005?
> thank you
> serge
>
>
|||Serge Myrand wrote:
> Hi everyones,
> Is there an 'easy' way to migrate an Access 2000 db to SQL Server 2000
> or 2005?
> thank you
> serge
To add to what others have said, 'easy' depends on how complicated your
database is. For instance, your VBA isn't going to get migrated. If
you have forms or reports, they will need some tweaking for sure.
Lastly, the Upsizing Wizard... I have yet to meet a database that it
cleanly migrated. There are always some modifications required.
Unfortunately, the errors that the Wizard reports are counterintuitive.
Good luck.
|||Thank very much
serge
6600Trilby@.gmail.com wrote:

> Yes, there is a utility for SQL Server 2000, that will import all your
> tables and data for you. I forget what it is called but it comes with
> enterprise manager. I am pretty sure your views will not be imported
> though as they use different languages.
|||Thank you very much
serge
Norman Yuan wrote:
[vbcol=seagreen]
> menu "Tools->Database Utilities->Upszing Wizard...". Note, after running the
> wizard, there may be still some manual modifications is required to the
> generated SQL Server DB, depending on how complicated your Access DB is.
> "Serge Myrand" <info@.softdelirium.qc.ca> wrote in message
> news:43DD164D.420B97F4@.softdelirium.qc.ca...
|||There is no report nor view but there are 165 tables
with many relations.
thank you very much
serge
Frank Rizzo wrote:

> Serge Myrand wrote:
> To add to what others have said, 'easy' depends on how complicated your
> database is. For instance, your VBA isn't going to get migrated. If
> you have forms or reports, they will need some tweaking for sure.
> Lastly, the Upsizing Wizard... I have yet to meet a database that it
> cleanly migrated. There are always some modifications required.
> Unfortunately, the errors that the Wizard reports are counterintuitive.
> Good luck.
|||I think he is talking about the upsizing wizard and it comes with Access -
not Enterprise manager. It's a menu option in the Access menu bar.
This posting is provided "AS IS" with no warranties, and confers no rights.
Use of included script samples are subject to the terms specified at
http://www.microsoft.com/info/cpyright.htm
"Serge Myrand" <info@.softdelirium.qc.ca> wrote in message
news:43DDEE1A.B3AD5819@.softdelirium.qc.ca...
> Thank very much
> serge
> 6600Trilby@.gmail.com wrote:
>