Help on migrating from SQL7 to SQL2K

Hi,
We just installed a new server with SQL2k (OS win2k) on it. We have an old
SQL7.0 server (OS NT4). It has a few databases, jobs, packages and etc. I
like to transfer and convert all the data from SQL 7.0 to the new SQL 2k
server. Can someone tell me what is the best way to do so?
Thanks,
SarahSG,
Might want to read:
http://www.microsoft.com/technet/pr...oy/sqlugrd.mspx
and
http://support.microsoft.com/defaul...kb;en-us;261334
HTH
Jerry
"SG" <sguo@.coopervision.ca> wrote in message
news:eh7GZE3yFHA.3812@.TK2MSFTNGP09.phx.gbl...
> Hi,
> We just installed a new server with SQL2k (OS win2k) on it. We have an old
> SQL7.0 server (OS NT4). It has a few databases, jobs, packages and etc. I
> like to transfer and convert all the data from SQL 7.0 to the new SQL 2k
> server. Can someone tell me what is the best way to do so?
> Thanks,
> Sarah
>
>|||Hi Jerry,
I found that there is a "Copy database wizard" on sql2k, would that be the
best solution in my case?
Thanks,
Sarah
"Jerry Spivey" <jspivey@.vestas-awt.com> wrote in message
news:OFsm4K3yFHA.2064@.TK2MSFTNGP09.phx.gbl...
> SG,
> Might want to read:
> http://www.microsoft.com/technet/pr...oy/sqlugrd.mspx
> and
> http://support.microsoft.com/defaul...kb;en-us;261334
> HTH
> Jerry
> "SG" <sguo@.coopervision.ca> wrote in message
> news:eh7GZE3yFHA.3812@.TK2MSFTNGP09.phx.gbl...
>|||Do you want to replace the existing SQL Server 7 with SQL Server 2000? If
so then the copy database wizard is probably not the best solution. This
wizard is useful at bringing a database over from an existing 7 install to a
new install of 2000 - easier to test database by database this way while
maintaining the originating install.
HTH
Jerry
"SG" <sguo@.coopervision.ca> wrote in message
news:e4GlMs3yFHA.1168@.TK2MSFTNGP15.phx.gbl...
> Hi Jerry,
> I found that there is a "Copy database wizard" on sql2k, would that be the
> best solution in my case?
> Thanks,
> Sarah
> "Jerry Spivey" <jspivey@.vestas-awt.com> wrote in message
> news:OFsm4K3yFHA.2064@.TK2MSFTNGP09.phx.gbl...
>

Help on migrating from SQL7 to SQL2K

Hi,
We just installed a new server with SQL2k (OS win2k) on it. We have an old
SQL7.0 server (OS NT4). It has a few databases, jobs, packages and etc. I
like to transfer and convert all the data from SQL 7.0 to the new SQL 2k
server. Can someone tell me what is the best way to do so?
Thanks,
SarahSG,
Might want to read:
http://www.microsoft.com/technet/prodtechnol/sql/2000/deploy/sqlugrd.mspx
and
http://support.microsoft.com/default.aspx?scid=kb;en-us;261334
HTH
Jerry
"SG" <sguo@.coopervision.ca> wrote in message
news:eh7GZE3yFHA.3812@.TK2MSFTNGP09.phx.gbl...
> Hi,
> We just installed a new server with SQL2k (OS win2k) on it. We have an old
> SQL7.0 server (OS NT4). It has a few databases, jobs, packages and etc. I
> like to transfer and convert all the data from SQL 7.0 to the new SQL 2k
> server. Can someone tell me what is the best way to do so?
> Thanks,
> Sarah
>
>|||Hi Jerry,
I found that there is a "Copy database wizard" on sql2k, would that be the
best solution in my case?
Thanks,
Sarah
"Jerry Spivey" <jspivey@.vestas-awt.com> wrote in message
news:OFsm4K3yFHA.2064@.TK2MSFTNGP09.phx.gbl...
> SG,
> Might want to read:
> http://www.microsoft.com/technet/prodtechnol/sql/2000/deploy/sqlugrd.mspx
> and
> http://support.microsoft.com/default.aspx?scid=kb;en-us;261334
> HTH
> Jerry
> "SG" <sguo@.coopervision.ca> wrote in message
> news:eh7GZE3yFHA.3812@.TK2MSFTNGP09.phx.gbl...
>> Hi,
>> We just installed a new server with SQL2k (OS win2k) on it. We have an
>> old
>> SQL7.0 server (OS NT4). It has a few databases, jobs, packages and etc. I
>> like to transfer and convert all the data from SQL 7.0 to the new SQL 2k
>> server. Can someone tell me what is the best way to do so?
>> Thanks,
>> Sarah
>>
>|||Do you want to replace the existing SQL Server 7 with SQL Server 2000? If
so then the copy database wizard is probably not the best solution. This
wizard is useful at bringing a database over from an existing 7 install to a
new install of 2000 - easier to test database by database this way while
maintaining the originating install.
HTH
Jerry
"SG" <sguo@.coopervision.ca> wrote in message
news:e4GlMs3yFHA.1168@.TK2MSFTNGP15.phx.gbl...
> Hi Jerry,
> I found that there is a "Copy database wizard" on sql2k, would that be the
> best solution in my case?
> Thanks,
> Sarah
> "Jerry Spivey" <jspivey@.vestas-awt.com> wrote in message
> news:OFsm4K3yFHA.2064@.TK2MSFTNGP09.phx.gbl...
>> SG,
>> Might want to read:
>> http://www.microsoft.com/technet/prodtechnol/sql/2000/deploy/sqlugrd.mspx
>> and
>> http://support.microsoft.com/default.aspx?scid=kb;en-us;261334
>> HTH
>> Jerry
>> "SG" <sguo@.coopervision.ca> wrote in message
>> news:eh7GZE3yFHA.3812@.TK2MSFTNGP09.phx.gbl...
>> Hi,
>> We just installed a new server with SQL2k (OS win2k) on it. We have an
>> old
>> SQL7.0 server (OS NT4). It has a few databases, jobs, packages and etc.
>> I
>> like to transfer and convert all the data from SQL 7.0 to the new SQL 2k
>> server. Can someone tell me what is the best way to do so?
>> Thanks,
>> Sarah
>>
>>
>sql

Help on migrating from SQL7 to SQL2K

Hi,
We just installed a new server with SQL2k (OS win2k) on it. We have an old
SQL7.0 server (OS NT4). It has a few databases, jobs, packages and etc. I
like to transfer and convert all the data from SQL 7.0 to the new SQL 2k
server. Can someone tell me what is the best way to do so?
Thanks,
Sarah
SG,
Might want to read:
http://www.microsoft.com/technet/pro...y/sqlugrd.mspx
and
http://support.microsoft.com/default...b;en-us;261334
HTH
Jerry
"SG" <sguo@.coopervision.ca> wrote in message
news:eh7GZE3yFHA.3812@.TK2MSFTNGP09.phx.gbl...
> Hi,
> We just installed a new server with SQL2k (OS win2k) on it. We have an old
> SQL7.0 server (OS NT4). It has a few databases, jobs, packages and etc. I
> like to transfer and convert all the data from SQL 7.0 to the new SQL 2k
> server. Can someone tell me what is the best way to do so?
> Thanks,
> Sarah
>
>
|||Hi Jerry,
I found that there is a "Copy database wizard" on sql2k, would that be the
best solution in my case?
Thanks,
Sarah
"Jerry Spivey" <jspivey@.vestas-awt.com> wrote in message
news:OFsm4K3yFHA.2064@.TK2MSFTNGP09.phx.gbl...
> SG,
> Might want to read:
> http://www.microsoft.com/technet/pro...y/sqlugrd.mspx
> and
> http://support.microsoft.com/default...b;en-us;261334
> HTH
> Jerry
> "SG" <sguo@.coopervision.ca> wrote in message
> news:eh7GZE3yFHA.3812@.TK2MSFTNGP09.phx.gbl...
>
|||Do you want to replace the existing SQL Server 7 with SQL Server 2000? If
so then the copy database wizard is probably not the best solution. This
wizard is useful at bringing a database over from an existing 7 install to a
new install of 2000 - easier to test database by database this way while
maintaining the originating install.
HTH
Jerry
"SG" <sguo@.coopervision.ca> wrote in message
news:e4GlMs3yFHA.1168@.TK2MSFTNGP15.phx.gbl...
> Hi Jerry,
> I found that there is a "Copy database wizard" on sql2k, would that be the
> best solution in my case?
> Thanks,
> Sarah
> "Jerry Spivey" <jspivey@.vestas-awt.com> wrote in message
> news:OFsm4K3yFHA.2064@.TK2MSFTNGP09.phx.gbl...
>

Help on changing the PW on SQL2000

Hi, all,
I got a problem to change the users' password from the VB
side. It is almost same as one from SQL7, and it works on
SQL7 but I have problem on SQL2000. It is ok when I run it
from QA, what's wrong? Do I need set ANSI NULLS?
Any one can help? Thanks you very much and have a good one
Abchawk
Here is the Stored procedure i wrote if it is sysadmin
to change others PW, the login will be the person who PW
will be changed, otherwise, the person changes his own PW,
in this case, login will be ' ')
CREATE PROCEDURE I_USER_CHANGE_PASSWORD_SP
(
@.LOGIN NVARCHAR(10)=' ',
@.OLDPASSWD NVARCHAR(10),
@.NEWPASSWD NVARCHAR(10)
) AS
DECLARE @.OUT INT
IF @.LOGIN <>' ' BEGIN
EXEC @.OUT = sp_password NULL ,
@.NEWPASSWD,@.LOGIN
END
ELSE BEGIN
EXEC @.OUT = sp_password
@.OLDPASSWD,@.NEWPASSWD
END
RETURN @.OUT
GO
****************************************
**************
The VB side code like this:
Set adoCommand = CreateObject("ADODB.Command")
mySQL = "I_USER_CHANGE_PASSWORD_SP "
With adoCommand
.ActiveConnection = strCnn
.CommandText = mySQL
.CommandTimeout = 100
.CommandType = adCmdStoredProc
.Parameters.Append .CreateParameter("RETURN",
adInteger, adParamReturnValue)
If SecurityLevel < 2 Or Trim(Me.txtLogin) =
userName Then
.Parameters.Append .CreateParameter
("Login", adWChar, adParamInput, 10, " ")
.Parameters.Append .CreateParameter
("OldPasswd", adWChar, adParamInput, 10, Trim
(Me.txtOldPassword))
Else
.Parameters.Append .CreateParameter
("Login", adWChar, adParamInput, 10, Trim(Me.txtLogin))
.Parameters.Append .CreateParameter
("OldPasswd", adWChar, adParamInput, 10, Null)
End If
.Parameters.Append .CreateParameter
("NewPasswd", adWChar, adParamInput, 10, Trim
(Me.txtNewPassword))
End With
adoCommand.Execute
OUT = adoCommand(0)
If OUT <> 1 Then
MsgBox "Change password successfully",
vbInformation
Else
MsgBox "Sorry,Changing password failured",
vbInformation
End If
Set adoCommand = Nothing
****************************************
******************Below is a VBScript code snippet that shows how to execute a proc with
parameters. This way, you don't have to build the SQL with properly quoted
strings.
Set cmd = CreateObject("ADODB.Command")
Set cmd.ActiveConnection = connection
cmd.CommandType = 'adCmdStoredProcedure
cmd.CommandText = "sp_addlogin"
Set pReturnCode = cmd.CreateParameter("@.RETURN_CODE")
pReturnCode.Type = adInteger
pReturnCode.Direction = 4 'adParamReturnValue
cmd.Parameters.Append pReturnCode
Set pLoginName = cmd.CreateParameter("@.loginame")
pLoginName.Type = adVarWChar
pLoginName.Direction = adParamInput
pLoginName.Size = 128
pLoginName.Value = "MyLogin"
cmd.Parameters.Append pLoginName
Set pLoginName = cmd.CreateParameter("@.passwd")
pLoginName.Type = adVarWChar
pLoginName.Direction = adParamInput
pLoginName.Size = 128
pLoginName.Value = "MyLoginPassword"
cmd.Parameters.Append pLoginName
cmd.Execute
'display return code
MsgBox cmd.Parameters(0).Name & "=" & cmd.Parameters(0).Value
connection.Close
Hope this helps.
Dan Guzman
SQL Server MVP
"abchawk" <anonymous@.discussions.microsoft.com> wrote in message
news:005d01c4d72f$1c866120$a601280a@.phx.gbl...
> Hi, All,
> I think I found the reason that cause the problem. It is
> the single quota ('). If I run SQL statement in VB
> like "sp_password '" & strOldPW & "','" & strNewPW & "'"
> it is not problem at all, but how can I do samething in VB
> using ado command? Does anyone know it?
> Samething for sp_addlogin, I create the login but can not
> access the DB because of Password. Using SQL statement
> like above, it is fine. just becasue the data type is
> sysname? For SQL 7 , double quota works fine, but not in
> SQL 2000
> Thanks and have a great day.
> hawk