Esport databases

I m having WIN NT 4 and SQl server 6.5 i wanted to shift to WIN 2003 server
and SQL server 2000 on a new machine how can transfer the old SQL 6.5
databaes to new SQL server 2000 on a new nachine
--
Yousuf Khan
ProgrammerYou can use several methods.
Backup and restore to newserver or Copy both mdf and ldf file to new server
and attach the database or use DTS.
any more question pls reply
hope this will help
Herbert
"Yousuf" wrote:
> I m having WIN NT 4 and SQl server 6.5 i wanted to shift to WIN 2003 server
> and SQL server 2000 on a new machine how can transfer the old SQL 6.5
> databaes to new SQL server 2000 on a new nachine
> --
> Yousuf Khan
> Programmer|||Herbert thanks for your reply
can you please write me the exact procedure shifting from old server to new
server with upgraded version I am having Tape Device or can i transfer of
import from 6.5 to 2000
--
Yousuf Khan
Programmer
"Herbert" wrote:
> You can use several methods.
> Backup and restore to newserver or Copy both mdf and ldf file to new server
> and attach the database or use DTS.
> any more question pls reply
> hope this will help
> Herbert
>
> "Yousuf" wrote:
> > I m having WIN NT 4 and SQl server 6.5 i wanted to shift to WIN 2003 server
> > and SQL server 2000 on a new machine how can transfer the old SQL 6.5
> > databaes to new SQL server 2000 on a new nachine
> > --
> > Yousuf Khan
> > Programmer|||U take full backup to ur local server drive. Copy that backup to new server
and using the All Tasks => restore option restore the DB to new server.
For backup and restore refer BOL
--
Herbert
"Yousuf" wrote:
> Herbert thanks for your reply
> can you please write me the exact procedure shifting from old server to new
> server with upgraded version I am having Tape Device or can i transfer of
> import from 6.5 to 2000
> --
> Yousuf Khan
> Programmer
>
> "Herbert" wrote:
> > You can use several methods.
> >
> > Backup and restore to newserver or Copy both mdf and ldf file to new server
> > and attach the database or use DTS.
> >
> > any more question pls reply
> >
> > hope this will help
> >
> > Herbert
> >
> >
> > "Yousuf" wrote:
> >
> > > I m having WIN NT 4 and SQl server 6.5 i wanted to shift to WIN 2003 server
> > > and SQL server 2000 on a new machine how can transfer the old SQL 6.5
> > > databaes to new SQL server 2000 on a new nachine
> > > --
> > > Yousuf Khan
> > > Programmer|||6.5 didn't have mdf files, and the storage format was different from the new architecture. So copy
db files or backup doesn't work.
SQL2K has an upgrade wizard that can upgrade from 6.5. Or, use DTS.
--
Tibor Karaszi, SQL Server MVP
http://www.karaszi.com/sqlserver/default.asp
http://www.solidqualitylearning.com/
Blog: http://solidqualitylearning.com/blogs/tibor/
"Herbert" <Herbert@.discussions.microsoft.com> wrote in message
news:CC047EAF-C9A5-4E92-B1E8-4C368296F52E@.microsoft.com...
> You can use several methods.
> Backup and restore to newserver or Copy both mdf and ldf file to new server
> and attach the database or use DTS.
> any more question pls reply
> hope this will help
> Herbert
>
> "Yousuf" wrote:
>> I m having WIN NT 4 and SQl server 6.5 i wanted to shift to WIN 2003 server
>> and SQL server 2000 on a new machine how can transfer the old SQL 6.5
>> databaes to new SQL server 2000 on a new nachine
>> --
>> Yousuf Khan
>> Programmer|||Hi,
As Tibor pointed out due to architectural changes you can not DETACH and
ATTACH the databases, as well as BACKUP and RESTORE will not
work.
The best method is to use the SQL server 2000 upgrade wizard.This converts
your Schema, logins, users, data and all other objects to sql 2000.
Every thing automatic.
Detailed steps from books online:-
How to perform a SQL Server version 6.5 to SQL Server 2000 upgrade using a
direct pipeline (SQL Server Upgrade Wizard)
Note To run the SQL Server Upgrade Wizard, you must have an instance of
Microsoft® SQL ServerT 2000 already installed on your computer.
To perform a SQL Server version 6.5 to SQL Server 2000 upgrade by named pipe
1.. On the Start menu, point to Programs/Microsoft SQL Server-Switch,
click SQL Server Upgrade Wizard, and then click Next.
2.. In the Data and Object Transfer screen, accept the default selections,
including Named pipe, and then click Next. Verification options are
recommended, but not required. Click Help for information.
3.. On the Logon screen, in the Server name box in the Export server (6.5)
group box, enter the name of the local or remote computer on which Microsoft
SQL Server version 6.5 is installed.
In the Administrator password ('sa') box, enter the sa password for SQL
Server 6.5, and then click Next.
Unless you have changed it already, the default system administrator
password for SQL Server 2000 is blank. Although the SQL Server 2000 default
for the sa password is blank, to conform with best security practices, it
should be changed to a strong password at the first opportunity.
For Import Server (2000), the server name is filled in. Enter the optional
startup arguments, if you want. Click Help for information. When you are
finished setting options, click Next.
4.. In the message box asking if you want to continue, click Yes if you
are ready to upgrade. The SQL Server Upgrade Wizard shuts down SQL Server
6.5 and starts SQL Server 2000.
5.. In the Code Page Selection screen, accept or change the default
settings, and then click Next.
6.. In the Database Selection screen, include the databases to upgrade.
Move any databases you do not want upgraded at this time to the Exclude
list, and then click Next.
Converting all databases is recommended.
7.. In the Database Creation dialog box, select Use the default
configuration or edit the default, and then click Next.
Click Edit to examine and make changes to the proposed disk configuration
within the layout utility. In the Proposed Database Layout box, make changes
as needed. Click Advanced to view Object Details and Drive Summary. When you
are finished, click Accept to return to the SQL Server Upgrade Wizard.
8.. In the System Configuration screen, in System objects to transfer,
select the object types to transfer from SQL Server 6.5 to SQL Server 2000:
a.. Server configuration
Login and remote login registrations and server configuration options
relevant to SQL Server 2000 are transferred as part of the version upgrade.
b.. Replication settings
All articles, subscriptions and publications of each selected database,
plus the distribution database, if any, are transferred and upgraded.
c.. SQL Executive settings
All tasks scheduled by SQL Executive are transferred and upgraded so
that SQL Server 2000 can schedule and run those tasks in SQL Server Agent.
9.. In the System Configuration screen, in Advanced settings, for ANSI
Nulls, select:
a.. Off, if ANSI nulls should not be used when stored procedures are
created. This is the default.
b.. On, if ANSI nulls should be used when stored procedures are created.
10.. In Quoted identifiers, select one of these options, and then click
Next:
a.. Mixed (or don't know), if some of your objects were created with
QUOTED_IDENTIFIER set to ON and others with it set to OFF, or if you are not
sure how they were created.
b.. Off, if all objects should be compiled with QUOTED_IDENTIFIER set to
OFF.
c.. On, if all objects should be compiled with QUOTED_IDENTIFIER set to
ON.
11.. In the Completing the SQL Server Wizard screen, view the summary of
choices you have made. Click View warnings and choices in notepad to open a
text version of the upgrade script. If all options are correct, click
Finish.
The SQL Server Upgrade Script Interpreter screen appears, with information
on the progress of the upgrade.
Thanks
Hari
SQL Server MVP
"Tibor Karaszi" <tibor_please.no.email_karaszi@.hotmail.nomail.com> wrote in
message news:eSmyRu7dFHA.1684@.TK2MSFTNGP09.phx.gbl...
> 6.5 didn't have mdf files, and the storage format was different from the
> new architecture. So copy
> db files or backup doesn't work.
> SQL2K has an upgrade wizard that can upgrade from 6.5. Or, use DTS.
> --
> Tibor Karaszi, SQL Server MVP
> http://www.karaszi.com/sqlserver/default.asp
> http://www.solidqualitylearning.com/
> Blog: http://solidqualitylearning.com/blogs/tibor/
>
> "Herbert" <Herbert@.discussions.microsoft.com> wrote in message
> news:CC047EAF-C9A5-4E92-B1E8-4C368296F52E@.microsoft.com...
>> You can use several methods.
>> Backup and restore to newserver or Copy both mdf and ldf file to new
>> server
>> and attach the database or use DTS.
>> any more question pls reply
>> hope this will help
>> Herbert
>>
>> "Yousuf" wrote:
>> I m having WIN NT 4 and SQl server 6.5 i wanted to shift to WIN 2003
>> server
>> and SQL server 2000 on a new machine how can transfer the old SQL 6.5
>> databaes to new SQL server 2000 on a new nachine
>> --
>> Yousuf Khan
>> Programmer
>
begin 666 note.gif
M1TE&.#EA# `+`(#_`(2&`,# P"'Y! $```$`+ `````,``L`0 (:C(\(H'S[
68%R0&ED;M7,'[%S2YW#1)VJ;4P``.P``
`
end