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
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
|||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:
[vbcol=seagreen]
> 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:
|||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:
[vbcol=seagreen]
> 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:
|||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...[vbcol=seagreen]
> 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:
|||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...
>
begin 666 note.gif
M1TE&.#EA# `+`(#_`(2&`,# P"'Y! $```$`+ `````,``L`0 (:C(\(H'S[
68%R0&ED;M7,'[%S2YW#1)VJ;4P``.P``
`
end
Showing posts with label win. Show all posts
Showing posts with label win. Show all posts
Monday, March 26, 2012
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 serve
r
> 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:
[vbcol=seagreen]
> You can use several methods.
> Backup and restore to newserver or Copy both mdf and ldf file to new serve
r
> and attach the database or use DTS.
> any more question pls reply
> hope this will help
> Herbert
>
> "Yousuf" wrote:
>|||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:
[vbcol=seagreen]
> Herbert thanks for your reply
> can you please write me the exact procedure shifting from old server to ne
w
> 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:
>|||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...[vbcol=seagreen]
> You can use several methods.
> Backup and restore to newserver or Copy both mdf and ldf file to new serve
r
> and attach the database or use DTS.
> any more question pls reply
> hope this will help
> Herbert
>
> "Yousuf" wrote:
>
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 serve
r
> 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:
[vbcol=seagreen]
> You can use several methods.
> Backup and restore to newserver or Copy both mdf and ldf file to new serve
r
> and attach the database or use DTS.
> any more question pls reply
> hope this will help
> Herbert
>
> "Yousuf" wrote:
>|||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:
[vbcol=seagreen]
> Herbert thanks for your reply
> can you please write me the exact procedure shifting from old server to ne
w
> 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:
>|||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...[vbcol=seagreen]
> You can use several methods.
> Backup and restore to newserver or Copy both mdf and ldf file to new serve
r
> and attach the database or use DTS.
> any more question pls reply
> hope this will help
> Herbert
>
> "Yousuf" wrote:
>
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
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
Monday, March 19, 2012
Errors on Datasource.aspx page
I have an installation of RS 2000 on a Win 2003 server.
I've started getting an error whenever I access the Data Source pages
using the Report Manager.
The page loads OK. But I cannot make any changes. For example, if I try
to change the "Connect Using" options from "Windows Integrated
Secuirty" to "Credentials stored securely ...", the radio button shows
the selection, but the required text boxes are not enabled, In the
bottom left corener of the IE status bar, "Error on Page" flashes.
The server log files and event logs show nothing regarding the error.
This happens on all Data Source pages on this server.
Any ideas?
It sounds like some of the javascript files are missing. Try reregistering asp.net client files by running aspnet_regiis -c from \windows\microsoft.net\framework\v1.1.4322.Friday, March 9, 2012
Errors Copying Data Base
I'm trying to copy a data base from one server to another. Both servers are running 2005 MSDE, on Win 2k3, the target server is 64 bit.
I'm using the Copy Database function, and ultimately it fails with the error in the event viewer in the targe machine:
Faulting application dtexec.exe, version 2005.90.1399.0, stamp 43500d1a, faulting module kernel32.dll, version 5.2.3790.1830, stamp 42438b79, debug? 0, fault address 0x0000000000027d0d.
I have tried both the Attach/Detach & the SMO method, and they both give me the same error. I have 'Repaired' the .NET framework on the target machine, with the same result.
Does anyone have any Suggestions? I really only need at this time to make one copy of the database.
Thanks
Phil
When you say "2005 MSDE", do you mean "2005 Express Edition"? You mentioned the target server is 64bit, is it IA64 or AMD64? My best guess is that you installed x86 version of SQL Server Express on AMD64 platform with WOW option.
Thanks,
Zhiqiang Feng
This posting is provided "AS IS" with no warranties, and confers no rights.
|||I have the x64 version of the Developer Edition of MS Sql Server 2005 installed on an AMD64 platform.
|||More completely, the source server is a 32 bit machine, with MS Sql Server Developer Edition 2005, the target machine is the x64 configuration.
I have tried to initiate the transfer from both ends, i.e. the from the platform with the database pushing it to the platform without the DB, and from the platform without the DB, pulling it from the platform with the db
|||Move the thread to the right alias. SSIS experts should be able to help out on your problem.
Thanks,
Zhiqiang Feng
This posting is provided "AS IS" with no warranties, and confers no rights.
|||the ssis transfer database task should help: http://msdn2.microsoft.com/en-us/library/ms141204.aspx
Subscribe to:
Posts (Atom)