Migrating Data from MsAccess

Hello
I'm trying to migrate the data from Access to MSDE database.
What is the easiest and most efficent method of doing it.
Also the AutoNumber field from Access, how does that move over to MSDE ?
Any help would be appreciated.
Thanks
Hemang
"Hemang Shah" <hemang@.hemang.net> wrote in message
news:YNSdneSqD-fQkGzcRVn-2A@.rogers.com...
> Hello
> I'm trying to migrate the data from Access to MSDE database.
> What is the easiest and most efficent method of doing it.
> Also the AutoNumber field from Access, how does that move over to MSDE ?
> Any help would be appreciated.
> Thanks
> Hemang
>
|||Buy Microsoft SQL Server Developers Version (if you don't already have it)
and use Enterprise Manager and the data import wizard to import your Access
data. Dealing with an AutoNumber column is easy, define your destination
columns as an IDENTITY column and allow identity insert when importing the
data.
Jim
"Hemang Shah" <hemang@.hemang.net> wrote in message
news:YNSdneSqD-fQkGzcRVn-2A@.rogers.com...
> Hello
> I'm trying to migrate the data from Access to MSDE database.
> What is the easiest and most efficent method of doing it.
> Also the AutoNumber field from Access, how does that move over to MSDE ?
> Any help would be appreciated.
> Thanks
> Hemang
>
|||Thanks Jim
Can you import to a MSDE database from Enterprise Manager ? Will that
database still be portable to MSDE ?
Thanks
"Jim Young" <thorium48@.hotmail.com> wrote in message
news:e$s2eN9$EHA.2552@.TK2MSFTNGP09.phx.gbl...
> Buy Microsoft SQL Server Developers Version (if you don't already have it)
> and use Enterprise Manager and the data import wizard to import your
> Access data. Dealing with an AutoNumber column is easy, define your
> destination columns as an IDENTITY column and allow identity insert when
> importing the data.
> Jim
> "Hemang Shah" <hemang@.hemang.net> wrote in message
> news:YNSdneSqD-fQkGzcRVn-2A@.rogers.com...
>
|||hi Hemang
Hemang Shah wrote:
> Thanks Jim
> Can you import to a MSDE database from Enterprise Manager ? Will that
> database still be portable to MSDE ?
>
SQL Server 2000 and MSDE 2000 share the same engine, as they are only
different edition of the same product, so MSDE database can be used by SQL
Server, but SQL Server dbs can be used by MSDE depending on it's limitation
on size...
regards
Andrea Montanari (Microsoft MVP - SQL Server)
http://www.asql.biz/DbaMgr.shtmhttp://italy.mvps.org
DbaMgr2k ver 0.10.0 - DbaMgr ver 0.56.0
(my vb6+sql-dmo little try to provide MS MSDE 1.0 and MSDE 2000 a visual
interface)
-- remove DMO to reply
|||Thanks Andrea
I used the upsized wizard of ms Access and it created a new database for me
in SQL and also retained the relationships and data, it was a breeze!
Thank You
"Andrea Montanari" <andrea.sqlDMO@.virgilio.it> wrote in message
news:35f9qhF4ispi8U1@.individual.net...
> hi Hemang
> Hemang Shah wrote:
> SQL Server 2000 and MSDE 2000 share the same engine, as they are only
> different edition of the same product, so MSDE database can be used by SQL
> Server, but SQL Server dbs can be used by MSDE depending on it's
> limitation
> on size...
> regards
> --
> Andrea Montanari (Microsoft MVP - SQL Server)
> http://www.asql.biz/DbaMgr.shtmhttp://italy.mvps.org
> DbaMgr2k ver 0.10.0 - DbaMgr ver 0.56.0
> (my vb6+sql-dmo little try to provide MS MSDE 1.0 and MSDE 2000 a visual
> interface)
> -- remove DMO to reply
>
sql