|
 |
asp_databases thread: sql server 6.5 to server 2000
Message #1 by "Eric Van Camp" <eric@a...> on Tue, 29 May 2001 18:15:50 +0200
|
|
i know, it is a big step but i want to migrate from 6.5 to 2000...
i have a sql 6.5 database which i want to run on a server 2000 database?
i thought i could take a shortcut using access?
can i reproduce the tables to access, the stored procedures..
i heard there is a possibility to connect from access 2000 to sql2000
to replicate the information from the access database?
somebody some suggestions?
Met Vriendelijke groet,
Eric Van Camp
Atmilestone BVBA
Trolieberg 74
3010 Kessel-lo
Tel:016/35.69.99
Fax:016/35.57.90
eric@a... <mailto:eric@a...>
<http://www.atmilestone.be/>
Message #2 by Michael Filip <mzcfilip@y...> on Tue, 29 May 2001 09:29:11 -0700 (PDT)
|
|
I too will soon need to go from Access 2000 --> SQL
Server 2000, and haven't yet had the time to research
how. I know it's not going to be very hard (well, I
hope), but if any of you have done it and could send a
few steps/procedures/problems/"things to watch for",
it would be much appreciated.
regards
- mike
--- Eric Van Camp <eric@a...> wrote:
> i know, it is a big step but i want to migrate from
> 6.5 to 2000...
> i have a sql 6.5 database which i want to run on a
> server 2000 database?
> i thought i could take a shortcut using access?
> can i reproduce the tables to access, the stored
> procedures..
> i heard there is a possibility to connect from
> access 2000 to sql2000 to replicate the information
> from the access database?
> somebody some suggestions?
>
> Met Vriendelijke groet,
> Eric Van Camp
> Atmilestone BVBA
> Trolieberg 74
> 3010 Kessel-lo
> Tel:016/35.69.99
> Fax:016/35.57.90
> eric@a... <mailto:eric@a...>
>
Message #3 by Hal Levy <hal.levy@s...> on Tue, 29 May 2001 15:20:58 -0400
|
|
Access 2K -> Sql 2K
This is pretty good. The access upsizer works as advertized.
the only thing you really need to do is re-mark your A2K "autonumber"
fields
as Identity fields in SQL 2K (the upsizer, last time I did it, didn't
do
that for me)
SQL 6.5 -> SQL 2K
Why go into access? SQL 2K will upgrade a SQL 6.5 Installation without
any
problems that I know of. If your moving to another server- then install
SQL
2K on the new server and do a BACKUP of the 6.5 machine and RESTORE on
the
2K machine.
Hal Levy
StarMedia Network, Inc.
Intranet Development Manager
-----Original Message-----
From: Michael Filip [mailto:mzcfilip@y...]
Sent: Tuesday, May 29, 2001 12:29 PM
To: ASP Databases
Subject: [asp_databases] Re: sql server 6.5 to server 2000
I too will soon need to go from Access 2000 --> SQL
Server 2000, and haven't yet had the time to research
how. I know it's not going to be very hard (well, I
hope), but if any of you have done it and could send a
few steps/procedures/problems/"things to watch for",
it would be much appreciated.
regards
- mike
--- Eric Van Camp <eric@a...> wrote:
> i know, it is a big step but i want to migrate from
> 6.5 to 2000...
> i have a sql 6.5 database which i want to run on a
> server 2000 database?
> i thought i could take a shortcut using access?
> can i reproduce the tables to access, the stored
> procedures..
> i heard there is a possibility to connect from
> access 2000 to sql2000 to replicate the information
> from the access database?
> somebody some suggestions?
>
> Met Vriendelijke groet,
> Eric Van Camp
|
|
|
View Cart
