Re: SQL Server 2005 Management Studio Express and Importing SQL 20

Tech-Archive recommends: Fix windows errors by optimizing your registry

From: "Andrew J. Kelly" <sqlmvpnooospam@xxxxxxxxxxxx>
Date: Wed, 23 May 2007 15:38:33 -0400

If the 2005 instance is not an Express edition then it should be fine. You
can also use sqlcmd to issue the restore or attach commands as well.

--
Andrew J. Kelly SQL MVP

"Paul" <Paul@xxxxxxxxxxxxxxxxxxxxxxxxx> wrote in message
news:6E67B0EA-A680-4B71-90E8-020D0991A791@xxxxxxxxxxxxxxxx

It was not a MSDE db. It is full-fledged SQL Server 2000 db.

"Andrew J. Kelly" wrote:

What edition is the 2000 db? If it was an MSDE db then you can simply
restore a full backup from the 2000 instance to the 2005 instance. Or
detach
and attach it.

--
Andrew J. Kelly SQL MVP

"Paul" <Paul@xxxxxxxxxxxxxxxxxxxxxxxxx> wrote in message
news:E09BC223-C67B-4C97-9679-D5ED53D458A1@xxxxxxxxxxxxxxxx

Can I use SQL Server 2005 Management Studio Express to import a SQL
2000
database into a SQL 2005 database?

Is there any tool that will do this?

Can I get a FREE copy of SQL Server 2005 Management Studio (NOT
Express)
somwhere?

References:
- Re: SQL Server 2005 Management Studio Express and Importing SQL 2000 D
  - From: Andrew J. Kelly

Prev by Date: Re: SQL server 2000 RS printing problem
Next by Date: Re: Using Import and Export Data tool from SQL Server to Oracle with Timestamp
Previous by thread: Re: SQL Server 2005 Management Studio Express and Importing SQL 2000 D
Next by thread: Re: SQL Server 2005 Management Studio Express and Importing SQL 20
Index(es):
- Date
- Thread

Relevant Pages

Re: whats in those Tlogs backups?
... Did you try the RESTORE WITH HEADERONLY or FILELISTONLY as Tibor suggested? ... Andrew J. Kelly SQL MVP ... >> Andrew J. Kelly SQL MVP ... >>> indexdefrag ...
(microsoft.public.sqlserver.server)
Re: Extremely high % Disk Time .. How is this possible??
... Andrew J. Kelly SQL MVP ... > Slicing them into logical drives may look better but it does not increase ... I prefer to look at disk queue ... >>> Andrew J. Kelly SQL MVP ...
(microsoft.public.sqlserver.clustering)
Re: Performance really poor if calling data from sql clients
... Andrew J. Kelly SQL MVP ... The TCP connection is running from the client ... On a computer running the test which is not the database hosting ...
(microsoft.public.sqlserver.clients)
Re: Procedure execution problem - Clients performances
... Again check the parameters and plan with a trace. ... Andrew J. Kelly SQL MVP ... Dim conn As New SqlConnection ...
(microsoft.public.sqlserver.clients)
Re: Performance really poor if calling data from sql clients
... Andrew J. Kelly SQL MVP ... The TCP connection is running from the ... Server already restarted several times (MSSQLSERVER, ...
(microsoft.public.sqlserver.clients)