Access 2000/2002 to SQL server

Hi everyones,
Is there a way to migrate an Access 2000 db to SQL Server 2000 or 2005?
thank you
serge
Hi,
You can use DTS to import all the data and create database.
Of course you'll have to setup security afterwards.
Danijel Novak
"Serge Myrand" <info@.softdelirium.qc.ca> wrote in message
news:43DCD052.D0C262F3@.softdelirium.qc.ca...
> Hi everyones,
> Is there a way to migrate an Access 2000 db to SQL Server 2000 or 2005?
> thank you
> serge
>
|||Apart from the dts package, You can use other methods as well:
From within ms-access : open database and go to Tools / Database utilities /
upsizing wizard
this wizard will generate a sql server database for you. You may have to do
some cleaning up in the sql database afterwards;
From SQL 2005 Management studio: connect to the sql server, in object
explorer rightclick on 'management' and choose import data. This opens the
import data wizard wich will create some sort of DTS package for you. I
personally have not tried this yet on sql 2005.
ON SQL 2000 enterprise manager there is a similar import data wizard.
From my own experience the Access wizard makes a more thorough conversion
(with primary keys and foreign keys added to the tables)
You may have to try different approaches on a test SQL server to find the
best result.
Jan D''Hondt
Jade bvba
Belgium
Database and .NET development
<Toto, I''ve got a feeling we''re not in Kansas anymore.>
"Serge Myrand" wrote:

> Hi everyones,
> Is there a way to migrate an Access 2000 db to SQL Server 2000 or 2005?
> thank you
> serge
>
sql

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:
>

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
sergeYes, 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 t
he
> 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:
>
>