Migrating Data from MsAccess -- sql server msde

sql server msde : Migrating Data from MsAccess

Jim Young
1/21/2005 8:04:01 AM

[quoted text, click to view]

Jim Young
1/21/2005 8:07:53 AM

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

[quoted text, click to view]

Hemang Shah
1/21/2005 8:39:30 AM

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
1/22/2005 9:59:21 AM

Thanks Jim

Can you import to a MSDE database from Enterprise Manager ? Will that
database still be portable to MSDE ?

Thanks

[quoted text, click to view]

Andrea Montanari
1/22/2005 4:29:21 PM

hi Hemang
[quoted text, click to view]

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.shtm http://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

Hemang Shah
1/24/2005 1:15:20 AM

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
[quoted text, click to view]

Got something to say? Click here to post a reply to this thread.

Don't see what you're looking for? Try a search.

View other messages about sql server msde

home · blog · groups

Questions? Comments? Contact the dn