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

Migrate Windows 2000 cluster to Windows 2003

Hi,
I am trying to determine the best method for rebuilding some existing
Windows 2000 clusters to Windows 2003. I have both SQL clusters and
some application clusters.
I do not want to upgrade the OS, but rather rebuild from scratch, one
node at a time, using the existing hardware. Is this possible? I am
having a hard time finding documentation on the best process for this
and want to follow the method which will provide me with the smallest
amount of downtime.
thanks for your help!
http://support.microsoft.com/?kbid=313037 explains how to upgrade, but like
you said, you really want to migrate. You can rebuild one node as a time,
and then rejoin the cluster.
Cheers,
Rod
MVP - Windows Server - Clustering
http://www.nw-america.com - Clustering
http://msmvps.com/clustering - Blog
"Mel" <Qtip027@.hotmail.com> wrote in message
news:a29a42e2.0411301100.34356ad9@.posting.google.c om...
> Hi,
> I am trying to determine the best method for rebuilding some existing
> Windows 2000 clusters to Windows 2003. I have both SQL clusters and
> some application clusters.
> I do not want to upgrade the OS, but rather rebuild from scratch, one
> node at a time, using the existing hardware. Is this possible? I am
> having a hard time finding documentation on the best process for this
> and want to follow the method which will provide me with the smallest
> amount of downtime.
> thanks for your help!
|||Been there, done that, bought the t-shirt. I prefer a mixed solution.
Upgrade THEN reload the OS. More work but less risk. Biggest thing is to
make absolutely sure you have correct 2003 drivers and software for your
SAN.
Geoff N. Hiten
Microsoft SQL Server MVP
Senior Database Administrator
Careerbuilder.com
I support the Professional Association for SQL Server
www.sqlpass.org
"Mel" <Qtip027@.hotmail.com> wrote in message
news:a29a42e2.0411301100.34356ad9@.posting.google.c om...
> Hi,
> I am trying to determine the best method for rebuilding some existing
> Windows 2000 clusters to Windows 2003. I have both SQL clusters and
> some application clusters.
> I do not want to upgrade the OS, but rather rebuild from scratch, one
> node at a time, using the existing hardware. Is this possible? I am
> having a hard time finding documentation on the best process for this
> and want to follow the method which will provide me with the smallest
> amount of downtime.
> thanks for your help!

Migrate Btrieve database to MSSQL 2000 database

Hi,
I've a Btrieve database which I want to migrate to MSSQL 2000 database. May
I know what is the method I can use?
Thanks
andrew
andrew wrote:
> Hi,
> I've a Btrieve database which I want to migrate to MSSQL 2000 database. May
> I know what is the method I can use?
> Thanks
> andrew
Run Butil -save to get the data from btrieve files into txt format
Create a DTS job to read the files into your MSSQL2K database.
Obviously you need to create the DB first.
|||Thanks mattis. But may I know where can I find this butil tools?
andrew
"mattis" wrote:

> andrew wrote:
> Run Butil -save to get the data from btrieve files into txt format
> Create a DTS job to read the files into your MSSQL2K database.
> Obviously you need to create the DB first.
>
|||Another option is to use BtSearch32 at www.nssdd.com. It will export Btrieve
to dbase or ascii which you can then import into about anything. Also if you
do not have the DDF files it will help you analyze the structure of the file
and build the DDF files.
Gil
"andrew" wrote:
[vbcol=seagreen]
> Thanks mattis. But may I know where can I find this butil tools?
> andrew
> "mattis" wrote:

Migrate Btrieve database to MSSQL 2000 database

Hi,
I've a Btrieve database which I want to migrate to MSSQL 2000 database. May
I know what is the method I can use?
Thanks
andrewandrew wrote:
> Hi,
> I've a Btrieve database which I want to migrate to MSSQL 2000 database. Ma
y
> I know what is the method I can use?
> Thanks
> andrew
Run Butil -save to get the data from btrieve files into txt format
Create a DTS job to read the files into your MSSQL2K database.
Obviously you need to create the DB first.|||Thanks mattis. But may I know where can I find this butil tools?
andrew
"mattis" wrote:

> andrew wrote:
> Run Butil -save to get the data from btrieve files into txt format
> Create a DTS job to read the files into your MSSQL2K database.
> Obviously you need to create the DB first.
>|||Another option is to use BtSearch32 at www.nssdd.com. It will export Btriev
e
to dbase or ascii which you can then import into about anything. Also if yo
u
do not have the DDF files it will help you analyze the structure of the file
and build the DDF files.
Gil
"andrew" wrote:
[vbcol=seagreen]
> Thanks mattis. But may I know where can I find this butil tools?
> andrew
> "mattis" wrote:
>

Migrate Btrieve database to MSSQL 2000 database

Hi,
I've a Btrieve database which I want to migrate to MSSQL 2000 database. May
I know what is the method I can use?
Thanks
andrewandrew wrote:
> Hi,
> I've a Btrieve database which I want to migrate to MSSQL 2000 database. May
> I know what is the method I can use?
> Thanks
> andrew
Run Butil -save to get the data from btrieve files into txt format
Create a DTS job to read the files into your MSSQL2K database.
Obviously you need to create the DB first.|||Thanks mattis. But may I know where can I find this butil tools?
andrew
"mattis" wrote:
> andrew wrote:
> > Hi,
> >
> > I've a Btrieve database which I want to migrate to MSSQL 2000 database. May
> > I know what is the method I can use?
> >
> > Thanks
> > andrew
> Run Butil -save to get the data from btrieve files into txt format
> Create a DTS job to read the files into your MSSQL2K database.
> Obviously you need to create the DB first.
>|||Another option is to use BtSearch32 at www.nssdd.com. It will export Btrieve
to dbase or ascii which you can then import into about anything. Also if you
do not have the DDF files it will help you analyze the structure of the file
and build the DDF files.
Gil
"andrew" wrote:
> Thanks mattis. But may I know where can I find this butil tools?
> andrew
> "mattis" wrote:
> > andrew wrote:
> > > Hi,
> > >
> > > I've a Btrieve database which I want to migrate to MSSQL 2000 database. May
> > > I know what is the method I can use?
> > >
> > > Thanks
> > > andrew
> >
> > Run Butil -save to get the data from btrieve files into txt format
> > Create a DTS job to read the files into your MSSQL2K database.
> >
> > Obviously you need to create the DB first.
> >