Wednesday, March 21, 2012

migrate server to another machine

Hi,
I will migrate the databases using the Microsoft SQL Database Migration
Wizard to another machine.
Can(how) I keep the same all username and password and data?
Usually hwo to do that? Thanks.http://databasejournal.com/features/mssql/article.php/2228611
That should get you what you need.
--
MeanOldDBA
derrickleggett@.hotmail.com
http://weblogs.sqlteam.com/derrickl
When life gives you a lemon, fire the DBA.
"js@.someone.com" wrote:
> Hi,
> I will migrate the databases using the Microsoft SQL Database Migration
> Wizard to another machine.
> Can(how) I keep the same all username and password and data?
> Usually hwo to do that? Thanks.
>
>|||Thanks for the help.
Can Microsoft SQL Database Migration Wizard used for
migration?
"MeanOldDBA" <MeanOldDBA@.discussions.microsoft.com> wrote in message
news:52EBC31B-6988-48E7-AD51-8E072A9B061C@.microsoft.com...
> http://databasejournal.com/features/mssql/article.php/2228611
> That should get you what you need.
> --
> MeanOldDBA
> derrickleggett@.hotmail.com
> http://weblogs.sqlteam.com/derrickl
> When life gives you a lemon, fire the DBA.
>
> "js@.someone.com" wrote:
>> Hi,
>> I will migrate the databases using the Microsoft SQL Database Migration
>> Wizard to another machine.
>> Can(how) I keep the same all username and password and data?
>> Usually hwo to do that? Thanks.
>>|||Hi,
The simplest way u can migrate ur database and logins are
restore the backup on the other server and trabfer all the logins from
dts package.
yes u can use microsoft migration wizard for migration.
from
Doller
js@.someone.com wrote:
> Thanks for the help.
> Can Microsoft SQL Database Migration Wizard used for
> migration?
>
> "MeanOldDBA" <MeanOldDBA@.discussions.microsoft.com> wrote in message
> news:52EBC31B-6988-48E7-AD51-8E072A9B061C@.microsoft.com...
> > http://databasejournal.com/features/mssql/article.php/2228611
> >
> > That should get you what you need.
> > --
> > MeanOldDBA
> > derrickleggett@.hotmail.com
> > http://weblogs.sqlteam.com/derrickl
> >
> > When life gives you a lemon, fire the DBA.
> >
> >
> > "js@.someone.com" wrote:
> >
> >> Hi,
> >> I will migrate the databases using the Microsoft SQL Database Migration
> >> Wizard to another machine.
> >> Can(how) I keep the same all username and password and data?
> >>
> >> Usually hwo to do that? Thanks.
> >>
> >>
> >>|||>> yes u can use microsoft migration wizard for migration.
Thanks, using migration wizard will auto keep the logins?
"doller" <sufianarif@.gmail.com> wrote in message
news:1128420204.497530.42080@.g14g2000cwa.googlegroups.com...
> Hi,
> The simplest way u can migrate ur database and logins are
> restore the backup on the other server and trabfer all the logins from
> dts package.
> yes u can use microsoft migration wizard for migration.
> from
> Doller
>
> js@.someone.com wrote:
>> Thanks for the help.
>> Can Microsoft SQL Database Migration Wizard used for
>> migration?
>>
>> "MeanOldDBA" <MeanOldDBA@.discussions.microsoft.com> wrote in message
>> news:52EBC31B-6988-48E7-AD51-8E072A9B061C@.microsoft.com...
>> > http://databasejournal.com/features/mssql/article.php/2228611
>> >
>> > That should get you what you need.
>> > --
>> > MeanOldDBA
>> > derrickleggett@.hotmail.com
>> > http://weblogs.sqlteam.com/derrickl
>> >
>> > When life gives you a lemon, fire the DBA.
>> >
>> >
>> > "js@.someone.com" wrote:
>> >
>> >> Hi,
>> >> I will migrate the databases using the Microsoft SQL Database
>> >> Migration
>> >> Wizard to another machine.
>> >> Can(how) I keep the same all username and password and data?
>> >>
>> >> Usually hwo to do that? Thanks.
>> >>
>> >>
>> >>
>|||Can you tell use exactly what "database migration wizard" is found. I don't have such tool on my SQL
Server 2000 installation. Do you refer to the "Copy Database Wizard"?
--
Tibor Karaszi, SQL Server MVP
http://www.karaszi.com/sqlserver/default.asp
http://www.solidqualitylearning.com/
Blog: http://solidqualitylearning.com/blogs/tibor/
"js" <js@.someone@.hotmail.com> wrote in message news:OIuy1XOyFHA.1132@.TK2MSFTNGP10.phx.gbl...
>> yes u can use microsoft migration wizard for migration.
> Thanks, using migration wizard will auto keep the logins?
>
> "doller" <sufianarif@.gmail.com> wrote in message
> news:1128420204.497530.42080@.g14g2000cwa.googlegroups.com...
>> Hi,
>> The simplest way u can migrate ur database and logins are
>> restore the backup on the other server and trabfer all the logins from
>> dts package.
>> yes u can use microsoft migration wizard for migration.
>> from
>> Doller
>>
>> js@.someone.com wrote:
>> Thanks for the help.
>> Can Microsoft SQL Database Migration Wizard used for
>> migration?
>>
>> "MeanOldDBA" <MeanOldDBA@.discussions.microsoft.com> wrote in message
>> news:52EBC31B-6988-48E7-AD51-8E072A9B061C@.microsoft.com...
>> > http://databasejournal.com/features/mssql/article.php/2228611
>> >
>> > That should get you what you need.
>> > --
>> > MeanOldDBA
>> > derrickleggett@.hotmail.com
>> > http://weblogs.sqlteam.com/derrickl
>> >
>> > When life gives you a lemon, fire the DBA.
>> >
>> >
>> > "js@.someone.com" wrote:
>> >
>> >> Hi,
>> >> I will migrate the databases using the Microsoft SQL Database Migration
>> >> Wizard to another machine.
>> >> Can(how) I keep the same all username and password and data?
>> >>
>> >> Usually hwo to do that? Thanks.
>> >>
>> >>
>> >>
>|||I don't know other tools, but found "Copy Database Wizard".
"Tibor Karaszi" <tibor_please.no.email_karaszi@.hotmail.nomail.com> wrote in
message news:%23v2vNKQyFHA.2880@.TK2MSFTNGP12.phx.gbl...
> Can you tell use exactly what "database migration wizard" is found. I
> don't have such tool on my SQL Server 2000 installation. Do you refer to
> the "Copy Database Wizard"?
> --
> Tibor Karaszi, SQL Server MVP
> http://www.karaszi.com/sqlserver/default.asp
> http://www.solidqualitylearning.com/
> Blog: http://solidqualitylearning.com/blogs/tibor/
>
> "js" <js@.someone@.hotmail.com> wrote in message
> news:OIuy1XOyFHA.1132@.TK2MSFTNGP10.phx.gbl...
>> yes u can use microsoft migration wizard for migration.
>> Thanks, using migration wizard will auto keep the logins?
>>
>> "doller" <sufianarif@.gmail.com> wrote in message
>> news:1128420204.497530.42080@.g14g2000cwa.googlegroups.com...
>> Hi,
>> The simplest way u can migrate ur database and logins are
>> restore the backup on the other server and trabfer all the logins from
>> dts package.
>> yes u can use microsoft migration wizard for migration.
>> from
>> Doller
>>
>> js@.someone.com wrote:
>> Thanks for the help.
>> Can Microsoft SQL Database Migration Wizard used for
>> migration?
>>
>> "MeanOldDBA" <MeanOldDBA@.discussions.microsoft.com> wrote in message
>> news:52EBC31B-6988-48E7-AD51-8E072A9B061C@.microsoft.com...
>> > http://databasejournal.com/features/mssql/article.php/2228611
>> >
>> > That should get you what you need.
>> > --
>> > MeanOldDBA
>> > derrickleggett@.hotmail.com
>> > http://weblogs.sqlteam.com/derrickl
>> >
>> > When life gives you a lemon, fire the DBA.
>> >
>> >
>> > "js@.someone.com" wrote:
>> >
>> >> Hi,
>> >> I will migrate the databases using the Microsoft SQL Database
>> >> Migration
>> >> Wizard to another machine.
>> >> Can(how) I keep the same all username and password and data?
>> >>
>> >> Usually hwo to do that? Thanks.
>> >>
>> >>
>> >>
>>
>|||I'm confused. You referred to a tool named "Data Migration Wizard". Are you now saying that the tool
you meant is actually the "Copy Database Wizard"?
--
Tibor Karaszi, SQL Server MVP
http://www.karaszi.com/sqlserver/default.asp
http://www.solidqualitylearning.com/
"js" <js@.someone@.hotmail.com> wrote in message news:OlKQjWRyFHA.2072@.TK2MSFTNGP14.phx.gbl...
>I don't know other tools, but found "Copy Database Wizard".
> "Tibor Karaszi" <tibor_please.no.email_karaszi@.hotmail.nomail.com> wrote in message
> news:%23v2vNKQyFHA.2880@.TK2MSFTNGP12.phx.gbl...
>> Can you tell use exactly what "database migration wizard" is found. I don't have such tool on my
>> SQL Server 2000 installation. Do you refer to the "Copy Database Wizard"?
>> --
>> Tibor Karaszi, SQL Server MVP
>> http://www.karaszi.com/sqlserver/default.asp
>> http://www.solidqualitylearning.com/
>> Blog: http://solidqualitylearning.com/blogs/tibor/
>>
>> "js" <js@.someone@.hotmail.com> wrote in message news:OIuy1XOyFHA.1132@.TK2MSFTNGP10.phx.gbl...
>> yes u can use microsoft migration wizard for migration.
>> Thanks, using migration wizard will auto keep the logins?
>>
>> "doller" <sufianarif@.gmail.com> wrote in message
>> news:1128420204.497530.42080@.g14g2000cwa.googlegroups.com...
>> Hi,
>> The simplest way u can migrate ur database and logins are
>> restore the backup on the other server and trabfer all the logins from
>> dts package.
>> yes u can use microsoft migration wizard for migration.
>> from
>> Doller
>>
>> js@.someone.com wrote:
>> Thanks for the help.
>> Can Microsoft SQL Database Migration Wizard used for
>> migration?
>>
>> "MeanOldDBA" <MeanOldDBA@.discussions.microsoft.com> wrote in message
>> news:52EBC31B-6988-48E7-AD51-8E072A9B061C@.microsoft.com...
>> > http://databasejournal.com/features/mssql/article.php/2228611
>> >
>> > That should get you what you need.
>> > --
>> > MeanOldDBA
>> > derrickleggett@.hotmail.com
>> > http://weblogs.sqlteam.com/derrickl
>> >
>> > When life gives you a lemon, fire the DBA.
>> >
>> >
>> > "js@.someone.com" wrote:
>> >
>> >> Hi,
>> >> I will migrate the databases using the Microsoft SQL Database Migration
>> >> Wizard to another machine.
>> >> Can(how) I keep the same all username and password and data?
>> >>
>> >> Usually hwo to do that? Thanks.
>> >>
>> >>
>> >>
>>
>>
>|||js wrote:
> I don't know other tools, but found "Copy Database Wizard".
> "Tibor Karaszi" <tibor_please.no.email_karaszi@.hotmail.nomail.com> wrote in
> message news:%23v2vNKQyFHA.2880@.TK2MSFTNGP12.phx.gbl...
>> Can you tell use exactly what "database migration wizard" is found. I
>> don't have such tool on my SQL Server 2000 installation. Do you refer to
>> the "Copy Database Wizard"?
>> --
>> Tibor Karaszi, SQL Server MVP
>> http://www.karaszi.com/sqlserver/default.asp
>> http://www.solidqualitylearning.com/
>> Blog: http://solidqualitylearning.com/blogs/tibor/
>>
>> "js" <js@.someone@.hotmail.com> wrote in message
>> news:OIuy1XOyFHA.1132@.TK2MSFTNGP10.phx.gbl...
>> yes u can use microsoft migration wizard for migration.
>> Thanks, using migration wizard will auto keep the logins?
>>
>> "doller" <sufianarif@.gmail.com> wrote in message
>> news:1128420204.497530.42080@.g14g2000cwa.googlegroups.com...
>> Hi,
>> The simplest way u can migrate ur database and logins are
>> restore the backup on the other server and trabfer all the logins from
>> dts package.
>> yes u can use microsoft migration wizard for migration.
>> from
>> Doller
>>
>> js@.someone.com wrote:
>> Thanks for the help.
>> Can Microsoft SQL Database Migration Wizard used for
>> migration?
>>
>> "MeanOldDBA" <MeanOldDBA@.discussions.microsoft.com> wrote in message
>> news:52EBC31B-6988-48E7-AD51-8E072A9B061C@.microsoft.com...
>> http://databasejournal.com/features/mssql/article.php/2228611
>> That should get you what you need.
>> --
>> MeanOldDBA
>> derrickleggett@.hotmail.com
>> http://weblogs.sqlteam.com/derrickl
>> When life gives you a lemon, fire the DBA.
>>
>> "js@.someone.com" wrote:
>>> Hi,
>>> I will migrate the databases using the Microsoft SQL Database
>>> Migration
>>> Wizard to another machine.
>>> Can(how) I keep the same all username and password and data?
>>>
>>> Usually hwo to do that? Thanks.
>>>
>>>
>>>
>
You can look up the description of the "Copy Database Wizard" in Books
On Line. It says that in addition to copying the actual databases, it
can also copy metadata like logins etc.
Regards
Steen|||> You can look up the description of the "Copy Database Wizard" in Books On Line. It says that in
> addition to copying the actual databases, it can also copy metadata like logins etc.
The reason I want to be certain what tool is referred to is that Copy Database Wizard does not carry
SID for SQL Server logins. So instead of letting CDW carry over logins, you use sp_help_revlogins
which will keep both password as well as SID for SQL server logins.
--
Tibor Karaszi, SQL Server MVP
http://www.karaszi.com/sqlserver/default.asp
http://www.solidqualitylearning.com/
"Steen Persson (DK)" <spe@.REMOVEdatea.dk> wrote in message
news:%2333kVZYyFHA.596@.TK2MSFTNGP12.phx.gbl...
> js wrote:
>> I don't know other tools, but found "Copy Database Wizard".
>> "Tibor Karaszi" <tibor_please.no.email_karaszi@.hotmail.nomail.com> wrote in message
>> news:%23v2vNKQyFHA.2880@.TK2MSFTNGP12.phx.gbl...
>> Can you tell use exactly what "database migration wizard" is found. I don't have such tool on my
>> SQL Server 2000 installation. Do you refer to the "Copy Database Wizard"?
>> --
>> Tibor Karaszi, SQL Server MVP
>> http://www.karaszi.com/sqlserver/default.asp
>> http://www.solidqualitylearning.com/
>> Blog: http://solidqualitylearning.com/blogs/tibor/
>>
>> "js" <js@.someone@.hotmail.com> wrote in message news:OIuy1XOyFHA.1132@.TK2MSFTNGP10.phx.gbl...
>> yes u can use microsoft migration wizard for migration.
>> Thanks, using migration wizard will auto keep the logins?
>>
>> "doller" <sufianarif@.gmail.com> wrote in message
>> news:1128420204.497530.42080@.g14g2000cwa.googlegroups.com...
>> Hi,
>> The simplest way u can migrate ur database and logins are
>> restore the backup on the other server and trabfer all the logins from
>> dts package.
>> yes u can use microsoft migration wizard for migration.
>> from
>> Doller
>>
>> js@.someone.com wrote:
>> Thanks for the help.
>> Can Microsoft SQL Database Migration Wizard used for
>> migration?
>>
>> "MeanOldDBA" <MeanOldDBA@.discussions.microsoft.com> wrote in message
>> news:52EBC31B-6988-48E7-AD51-8E072A9B061C@.microsoft.com...
>>> http://databasejournal.com/features/mssql/article.php/2228611
>>>
>>> That should get you what you need.
>>> --
>>> MeanOldDBA
>>> derrickleggett@.hotmail.com
>>> http://weblogs.sqlteam.com/derrickl
>>>
>>> When life gives you a lemon, fire the DBA.
>>>
>>>
>>> "js@.someone.com" wrote:
>>>
>>> Hi,
>>> I will migrate the databases using the Microsoft SQL Database Migration
>>> Wizard to another machine.
>>> Can(how) I keep the same all username and password and data?
>>>
>>> Usually hwo to do that? Thanks.
>>>
>>>
>>>
>>
> You can look up the description of the "Copy Database Wizard" in Books On Line. It says that in
> addition to copying the actual databases, it can also copy metadata like logins etc.
> Regards
> Steensql

No comments:

Post a Comment