Migrating from Access 2000 to SQL Server

Hey All,
Migrating from Access 2000 to SQL Server 6.5 and am experiencing some difficulty...Using the database utilities -> wizard, use existing database, have File DSN created on Server, select it and the login appears. Enter the login and get error message:

"Reserved error (-1038); there is no message for this error"

I cannot locate any info on. If someone knows anything I would really appreciate your input.

Thanks,
soniaI thought I would add some info for you...

Now, normally when you specify the DSN (which is on a network) it prompts you for the user login but when I am in the wizard I didn't get the prompt, I had to actually use windows explorer, go to the correct server and when I selected it there I get the prompt, and I enter the correct user name/password and then the share folders appear. After I did that, the shared folders appear for me when using the wizard.

I located the error meaning in the reserved error refernces: JET_errBufferTooSmall -1038 Buffer is too small. I don't know what this means I should do... If someone knows anything I would really appreciate your input.

Thanks, Desperately hoping someone knows something
Ssql

Migrating AS2000 to AS2005 on two seperate machines

Hi champs!

I have two seperates machines, one SQL2000 with some Cubes, and one with sql2005 and AS 2005.

I've tried the migrate wizard, but the sql2005 machines cannot connect to the sql2000 machine through OLAP connection.

The two machines ar in the same workgroup, but not in a domain.

Do I have to make a linked server connection? and if so how exactly is the syntax for connecting to a 2000 OLAP cubes?

I've tried to install AS2000 on my sql2005 machine, but that will not work.

I cannot restore AS2000 cubes on the AS2005 either.

/Many thanks

For one, to be able to install AS2000 on AS2005 machine you need to make sure you are running Analysis Server as named instance.

You can ether reinstall AS2005 and choose it to be named instance or use ASInstanceRename utility to rename defult instance. After that you should be able to install AS2000.

As for not being able to migrate from remote machine, if you choose to go that way. Try first installing AS2000 tools- Analysis Manager and use and work out through process of being able to use that to remotely access AS2000 server. http://www.microsoft.com/technet/prodtechnol/sql/2000/maintain/anservog.mspx

Edward.
--
This posting is provided "AS IS" with no warranties, and confers no rights.

Migrating AS2000 to AS2005 on two seperate machines

Hi champs!

I have two seperates machines, one SQL2000 with some Cubes, and one with sql2005 and AS 2005.

I've tried the migrate wizard, but the sql2005 machines cannot connect to the sql2000 machine through OLAP connection.

The two machines ar in the same workgroup, but not in a domain.

Do I have to make a linked server connection? and if so how exactly is the syntax for connecting to a 2000 OLAP cubes?

I've tried to install AS2000 on my sql2005 machine, but that will not work.

I cannot restore AS2000 cubes on the AS2005 either.

/Many thanks

For one, to be able to install AS2000 on AS2005 machine you need to make sure you are running Analysis Server as named instance.

You can ether reinstall AS2005 and choose it to be named instance or use ASInstanceRename utility to rename defult instance. After that you should be able to install AS2000.

As for not being able to migrate from remote machine, if you choose to go that way. Try first installing AS2000 tools- Analysis Manager and use and work out through process of being able to use that to remotely access AS2000 server. http://www.microsoft.com/technet/prodtechnol/sql/2000/maintain/anservog.mspx

Edward.
--
This posting is provided "AS IS" with no warranties, and confers no rights.

sql

Migrate w/o upgrade wizard

Hello,
I want to migrate my 6.5 DBs to SQL2K. Problem is that I can't get the
Upgrade Wizard's named pipe transfer to work in two server environment
(one of them is the latest WinNT4 and the other - the latest Win2K).
I've simply lost my patience reading white papers and trying to get it
running. So now I'm thinking of doing w/o it.
I think the easiest way would be to: (1) install a replica of original
6.5 on a spare server along with a fresh copy of SQL2K, (2) do a single
machine upgrade (using wizard), (3) from the spare SQL2K transfer master
and msdb stuff and new DB's to a production SQL2K.
This approach might be inept though. What would be the best/tested way
to go?
Many thanks,
Pablo
Hi,
Yes, I agree with your approach. But I suggest you to do the activity in
your SQL 6.5 machine itself. Because the SQL 2000 installing will not
touch/tamper SQL 2000. This will be a totally new copy.
Steps
1. Install SQL 2000 and sp3a in the SQL 6.5 machine, provided you have
enough space in hard disk to do upgrade
(We should have atleast 1.5 times data space in SQL 6.5)
2. Run the upgrade wizard on all system and required user databases
3. Once the upgrade is successful , you can move all the SQL 2000 databases
to New machine with SQL 2000 and SP3a.
4. Once the SQL 2000 is up in new Server, Change the SQL server name using
SP_DROPSERVER <Old_Server_name>
and SP_ADDSERVER <Server>,LOCAL
Thanks
Hari
MCDBA
"msnews.microsoft.com" <pablo@.this_isnt_my_email.cc> wrote in message
news:uEf0aF8KEHA.620@.TK2MSFTNGP10.phx.gbl...
> Hello,
> I want to migrate my 6.5 DBs to SQL2K. Problem is that I can't get the
> Upgrade Wizard's named pipe transfer to work in two server environment
> (one of them is the latest WinNT4 and the other - the latest Win2K).
> I've simply lost my patience reading white papers and trying to get it
> running. So now I'm thinking of doing w/o it.
> I think the easiest way would be to: (1) install a replica of original
> 6.5 on a spare server along with a fresh copy of SQL2K, (2) do a single
> machine upgrade (using wizard), (3) from the spare SQL2K transfer master
> and msdb stuff and new DB's to a production SQL2K.
> This approach might be inept though. What would be the best/tested way
> to go?
> --
> Many thanks,
> Pablo
>

Migrate w/o upgrade wizard

Hello,
I want to migrate my 6.5 DBs to SQL2K. Problem is that I can't get the
Upgrade Wizard's named pipe transfer to work in two server environment
(one of them is the latest WinNT4 and the other - the latest Win2K).
I've simply lost my patience reading white papers and trying to get it
running. So now I'm thinking of doing w/o it.
I think the easiest way would be to: (1) install a replica of original
6.5 on a spare server along with a fresh copy of SQL2K, (2) do a single
machine upgrade (using wizard), (3) from the spare SQL2K transfer master
and msdb stuff and new DB's to a production SQL2K.
This approach might be inept though. What would be the best/tested way
to go?
--
Many thanks,
PabloHi,
Yes, I agree with your approach. But I suggest you to do the activity in
your SQL 6.5 machine itself. Because the SQL 2000 installing will not
touch/tamper SQL 2000. This will be a totally new copy.
Steps
1. Install SQL 2000 and sp3a in the SQL 6.5 machine, provided you have
enough space in hard disk to do upgrade
(We should have atleast 1.5 times data space in SQL 6.5)
2. Run the upgrade wizard on all system and required user databases
3. Once the upgrade is successful , you can move all the SQL 2000 databases
to New machine with SQL 2000 and SP3a.
4. Once the SQL 2000 is up in new Server, Change the SQL server name using
SP_DROPSERVER <Old_Server_name>
and SP_ADDSERVER <Server>,LOCAL
Thanks
Hari
MCDBA
"msnews.microsoft.com" <pablo@.this_isnt_my_email.cc> wrote in message
news:uEf0aF8KEHA.620@.TK2MSFTNGP10.phx.gbl...
> Hello,
> I want to migrate my 6.5 DBs to SQL2K. Problem is that I can't get the
> Upgrade Wizard's named pipe transfer to work in two server environment
> (one of them is the latest WinNT4 and the other - the latest Win2K).
> I've simply lost my patience reading white papers and trying to get it
> running. So now I'm thinking of doing w/o it.
> I think the easiest way would be to: (1) install a replica of original
> 6.5 on a spare server along with a fresh copy of SQL2K, (2) do a single
> machine upgrade (using wizard), (3) from the spare SQL2K transfer master
> and msdb stuff and new DB's to a production SQL2K.
> This approach might be inept though. What would be the best/tested way
> to go?
> --
> Many thanks,
> Pablo
>

Migrate w/o upgrade wizard

Hello,
I want to migrate my 6.5 DBs to SQL2K. Problem is that I can't get the
Upgrade Wizard's named pipe transfer to work in two server environment
(one of them is the latest WinNT4 and the other - the latest Win2K).
I've simply lost my patience reading white papers and trying to get it
running. So now I'm thinking of doing w/o it.
I think the easiest way would be to: (1) install a replica of original
6.5 on a spare server along with a fresh copy of SQL2K, (2) do a single
machine upgrade (using wizard), (3) from the spare SQL2K transfer master
and msdb stuff and new DB's to a production SQL2K.
This approach might be inept though. What would be the best/tested way
to go?
Many thanks,
PabloHi,
Yes, I agree with your approach. But I suggest you to do the activity in
your SQL 6.5 machine itself. Because the SQL 2000 installing will not
touch/tamper SQL 2000. This will be a totally new copy.
Steps
1. Install SQL 2000 and sp3a in the SQL 6.5 machine, provided you have
enough space in hard disk to do upgrade
(We should have atleast 1.5 times data space in SQL 6.5)
2. Run the upgrade wizard on all system and required user databases
3. Once the upgrade is successful , you can move all the SQL 2000 databases
to New machine with SQL 2000 and SP3a.
4. Once the SQL 2000 is up in new Server, Change the SQL server name using
SP_DROPSERVER <Old_Server_name>
and SP_ADDSERVER <Server>,LOCAL
Thanks
Hari
MCDBA
"msnews.microsoft.com" <pablo@.this_isnt_my_email.cc> wrote in message
news:uEf0aF8KEHA.620@.TK2MSFTNGP10.phx.gbl...
> Hello,
> I want to migrate my 6.5 DBs to SQL2K. Problem is that I can't get the
> Upgrade Wizard's named pipe transfer to work in two server environment
> (one of them is the latest WinNT4 and the other - the latest Win2K).
> I've simply lost my patience reading white papers and trying to get it
> running. So now I'm thinking of doing w/o it.
> I think the easiest way would be to: (1) install a replica of original
> 6.5 on a spare server along with a fresh copy of SQL2K, (2) do a single
> machine upgrade (using wizard), (3) from the spare SQL2K transfer master
> and msdb stuff and new DB's to a production SQL2K.
> This approach might be inept though. What would be the best/tested way
> to go?
> --
> Many thanks,
> Pablo
>sql

migrate sql2k dts packages to sql2k5

new to sql2k5.
i have some sql2k dts packages i migrated to sql2k5 using wizard and
they showed up under intergration services, stored packages, msdb, but
I can't open or edit any of the package.
For the same packages, if I saved them as external file in sql2k, then
import them in sql2k5, they will show up in SSMS, management, legacy,
DTS folder, and if had downloaded the Microsoft SQL Server 2000 DTS
Designer Components , I can open and edit the packages.
This is all very confusing to me.
first, why the dts showed up at different place in sql2k5 (what's the
difference between import and migrate?)
2nd, how to edit the migrated dts packages?
3rd, in sql2k, dts package is part of msdb, as long as I backup msdb, I
can restore all the pckages, how about in sql2k5, where are dts being
stored and are they still part of msdb?
thank you.=== Steve L === wrote:
> new to sql2k5.
> i have some sql2k dts packages i migrated to sql2k5 using wizard and
> they showed up under intergration services, stored packages, msdb, but
> I can't open or edit any of the package.
> For the same packages, if I saved them as external file in sql2k, then
> import them in sql2k5, they will show up in SSMS, management, legacy,
> DTS folder, and if had downloaded the Microsoft SQL Server 2000 DTS
> Designer Components , I can open and edit the packages.
> This is all very confusing to me.
> first, why the dts showed up at different place in sql2k5 (what's the
> difference between import and migrate?)
> 2nd, how to edit the migrated dts packages?
> 3rd, in sql2k, dts package is part of msdb, as long as I backup msdb, I
> can restore all the pckages, how about in sql2k5, where are dts being
> stored and are they still part of msdb?
> thank you.
>
DTS doesn't exist in SQL 2005, it has been replaced with Integration
Services...|||DTS services is no loginer in sql2k5, but you can still import or
migrate sql2k dts to it. I think you are missing what I asked in my
posting.
Tracy McKibben wrote:
> === Steve L === wrote:
> DTS doesn't exist in SQL 2005, it has been replaced with Integration
> Services...

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

Microsoft SQL Server Upgrade Wizard

I need to convert from SQL Server 7 to 2000 and I have the 2000 installation
media - but where do I find the Microsoft SQL Server Upgrade Wizard ? Is it
included in the installation cd? or do I need to get a different product?Are you installing on a new server or upgrading an existing SQL 7 box?
In either case, you should have the option to install the upgrade wizard =
during the installation.
Moving databases from SQL7 to SQL2k is easy -- simply back them up and =
restore them to the 2k box. Note: it is not possible to go the other =
way! (at least not with BACKUP and RESTORE).
--=20
Keith
"confused" <anonymous@.discussions.microsoft.com> wrote in message =
news:44F65E3A-8EC2-45C5-8E1B-23B9868DF4D1@.microsoft.com...
> I need to convert from SQL Server 7 to 2000 and I have the 2000 =
installation media - but where do I find the Microsoft SQL Server =
Upgrade Wizard ? Is it included in the installation cd? or do I need to =
get a different product?