|
 |
access thread: Transfer info from Access to SQL
Message #1 by "Simon Garstin" <sgarstin@t...> on Thu, 6 Dec 2001 11:15:23
|
|
Hi all,
I have a web site which uses Access database. We want to transfer the site
to a new host using SQL server.
The Access database can obviously be downloaded to my PC.
What we then need is a quick way to then "read" the Access database
configuration and data, eg. into a file, which can then be uploaded and
quickly "written" to the on-line SQL Server database so that it has the
same configuration and data.
The MYSQL database uses the command "mysqldump" in this way and it's very
effective - it takes about as long as the time to type a couple of
commands and do a quick FTP upload.
Is there a similar way to do this with Microsoft ?
thanks
Simon Garstin
Message #2 by "Helga Y. Anagnostopoulos" <helga@k...> on Thu, 6 Dec 2001 13:14:27 +0200
|
|
Try using the following:
SQL SERVER/Enterprice Manager/Right-click database/All tasks/Import.....
Helga
-----Original Message-----
From: Simon Garstin [mailto:sgarstin@t...]
Sent: Thursday, December 06, 2001 11:15 AM
To: Access
Subject: [access] Transfer info from Access to SQL
Hi all,
I have a web site which uses Access database. We want to transfer the site
to a new host using SQL server.
The Access database can obviously be downloaded to my PC.
What we then need is a quick way to then "read" the Access database
configuration and data, eg. into a file, which can then be uploaded and
quickly "written" to the on-line SQL Server database so that it has the
same configuration and data.
The MYSQL database uses the command "mysqldump" in this way and it's very
effective - it takes about as long as the time to type a couple of
commands and do a quick FTP upload.
Is there a similar way to do this with Microsoft ?
thanks
Simon Garstin
Message #3 by "Simon Garstin" <sales@o...> on Thu, 6 Dec 2001 13:03:12 -0000
|
|
Thanks Helga,
unfortunately I may not have access to Enterprise Manager becuase it will be
on someone else's server.
Also *what* would I import, and how would I generate it (the thing to
import) from Access ?
cheers
Simon Garstin
----- Original Message -----
From: Helga Y. Anagnostopoulos <helga@k...>
To: Access <access@p...>
Sent: Thursday, December 06, 2001 11:14 AM
Subject: [access] RE: Transfer info from Access to SQL
> Try using the following:
>
> SQL SERVER/Enterprice Manager/Right-click database/All tasks/Import.....
>
> Helga
>
> -----Original Message-----
> From: Simon Garstin [mailto:sgarstin@t...]
> Sent: Thursday, December 06, 2001 11:15 AM
> To: Access
> Subject: [access] Transfer info from Access to SQL
>
>
> Hi all,
>
> I have a web site which uses Access database. We want to transfer the site
> to a new host using SQL server.
>
> The Access database can obviously be downloaded to my PC.
> What we then need is a quick way to then "read" the Access database
> configuration and data, eg. into a file, which can then be uploaded and
> quickly "written" to the on-line SQL Server database so that it has the
> same configuration and data.
>
> The MYSQL database uses the command "mysqldump" in this way and it's very
> effective - it takes about as long as the time to type a couple of
> commands and do a quick FTP upload.
>
> Is there a similar way to do this with Microsoft ?
>
>
>
> thanks
>
> Simon Garstin
>
>
>
>
>
|
|
|
View Cart
