migrate linked servers

Hello everyone,
I'd like to learn how I should go about moving my linked servers from on sql
server to another sql server. Has anyone done this before?
Thanks
Chieko
Hi,
Execute the script in query analyzer with text output and copy the result to
destination server and execute it.
(Script from old post)
select 'exec sp_addlinkedserver @.server=''' + srvname + '''' +
isnull(', @.srvproduct=''' + nullif(srvproduct, '')+ '''', '') +
isnull(', @.provider=''' + nullif(providername, '')+ '''', '') +
isnull(', @.datasrc=''' + nullif(datasource, '')+ '''',
'')+char(10)+'go'
from master..sysservers
This will help you to move the linked servers, but the security credentials
you need to define manually.
Thanks
Hari
MCDBA
"Chieko Kuroda" <ckuroda@.unch.unc.edu> wrote in message
news:#o#bX8uTEHA.1244@.TK2MSFTNGP10.phx.gbl...
> Hello everyone,
> I'd like to learn how I should go about moving my linked servers from on
sql
> server to another sql server. Has anyone done this before?
> Thanks
> Chieko
>
|||Thanks, I figure out that if I backed up the master database on the old
server and restored it on the new server the linked servers were add during
the restore process.
Chieko
"Hari Prasad" <hari_prasad_k@.hotmail.com> wrote in message
news:eDRLL3vTEHA.504@.TK2MSFTNGP11.phx.gbl...
> Hi,
>
> Execute the script in query analyzer with text output and copy the result
to
> destination server and execute it.
> (Script from old post)
> select 'exec sp_addlinkedserver @.server=''' + srvname + '''' +
> isnull(', @.srvproduct=''' + nullif(srvproduct, '')+ '''', '') +
> isnull(', @.provider=''' + nullif(providername, '')+ '''', '') +
> isnull(', @.datasrc=''' + nullif(datasource, '')+ '''',
> '')+char(10)+'go'
> from master..sysservers
> This will help you to move the linked servers, but the security
credentials
> you need to define manually.
> Thanks
> Hari
> MCDBA
> "Chieko Kuroda" <ckuroda@.unch.unc.edu> wrote in message
> news:#o#bX8uTEHA.1244@.TK2MSFTNGP10.phx.gbl...
> sql
>
|||Hi,
OK, That is also a approch. I was under the impression that you just need to
move Linked servers only.
If you restore the Master database, it will load all logins, databases,
configurations,....If
your destination server is of same configuration as source then your
solution will work well.
If the configurations is different then the restore will cause the database
to go to suspect status and
might cause the service startup failure.
Since it works fine, no need to worry.
Thanks
Hari
MCDBA
"Chieko Kuroda" <ckuroda@.unch.unc.edu> wrote in message
news:u#D4GAxTEHA.156@.TK2MSFTNGP12.phx.gbl...
> Thanks, I figure out that if I backed up the master database on the old
> server and restored it on the new server the linked servers were add
during[vbcol=seagreen]
> the restore process.
> Chieko
> "Hari Prasad" <hari_prasad_k@.hotmail.com> wrote in message
> news:eDRLL3vTEHA.504@.TK2MSFTNGP11.phx.gbl...
result[vbcol=seagreen]
> to
> credentials
on
>
sql

migrate linked servers

Hello everyone,
I'd like to learn how I should go about moving my linked servers from on sql
server to another sql server. Has anyone done this before?
Thanks
ChiekoHi,
Execute the script in query analyzer with text output and copy the result to
destination server and execute it.
(Script from old post)
select 'exec sp_addlinkedserver @.server=''' + srvname + '''' +
isnull(', @.srvproduct=''' + nullif(srvproduct, '')+ '''', '') +
isnull(', @.provider=''' + nullif(providername, '')+ '''', '') +
isnull(', @.datasrc=''' + nullif(datasource, '')+ '''',
'')+char(10)+'go'
from master..sysservers
This will help you to move the linked servers, but the security credentials
you need to define manually.
Thanks
Hari
MCDBA
"Chieko Kuroda" <ckuroda@.unch.unc.edu> wrote in message
news:#o#bX8uTEHA.1244@.TK2MSFTNGP10.phx.gbl...
> Hello everyone,
> I'd like to learn how I should go about moving my linked servers from on
sql
> server to another sql server. Has anyone done this before?
> Thanks
> Chieko
>|||Thanks, I figure out that if I backed up the master database on the old
server and restored it on the new server the linked servers were add during
the restore process.
Chieko
"Hari Prasad" <hari_prasad_k@.hotmail.com> wrote in message
news:eDRLL3vTEHA.504@.TK2MSFTNGP11.phx.gbl...
> Hi,
>
> Execute the script in query analyzer with text output and copy the result
to
> destination server and execute it.
> (Script from old post)
> select 'exec sp_addlinkedserver @.server=''' + srvname + '''' +
> isnull(', @.srvproduct=''' + nullif(srvproduct, '')+ '''', '') +
> isnull(', @.provider=''' + nullif(providername, '')+ '''', '') +
> isnull(', @.datasrc=''' + nullif(datasource, '')+ '''',
> '')+char(10)+'go'
> from master..sysservers
> This will help you to move the linked servers, but the security
credentials
> you need to define manually.
> Thanks
> Hari
> MCDBA
> "Chieko Kuroda" <ckuroda@.unch.unc.edu> wrote in message
> news:#o#bX8uTEHA.1244@.TK2MSFTNGP10.phx.gbl...
> > Hello everyone,
> > I'd like to learn how I should go about moving my linked servers from on
> sql
> > server to another sql server. Has anyone done this before?
> > Thanks
> > Chieko
> >
> >
>|||Hi,
OK, That is also a approch. I was under the impression that you just need to
move Linked servers only.
If you restore the Master database, it will load all logins, databases,
configurations,....If
your destination server is of same configuration as source then your
solution will work well.
If the configurations is different then the restore will cause the database
to go to suspect status and
might cause the service startup failure.
Since it works fine, no need to worry.
--
Thanks
Hari
MCDBA
"Chieko Kuroda" <ckuroda@.unch.unc.edu> wrote in message
news:u#D4GAxTEHA.156@.TK2MSFTNGP12.phx.gbl...
> Thanks, I figure out that if I backed up the master database on the old
> server and restored it on the new server the linked servers were add
during
> the restore process.
> Chieko
> "Hari Prasad" <hari_prasad_k@.hotmail.com> wrote in message
> news:eDRLL3vTEHA.504@.TK2MSFTNGP11.phx.gbl...
> > Hi,
> >
> >
> > Execute the script in query analyzer with text output and copy the
result
> to
> > destination server and execute it.
> >
> > (Script from old post)
> >
> > select 'exec sp_addlinkedserver @.server=''' + srvname + '''' +
> > isnull(', @.srvproduct=''' + nullif(srvproduct, '')+ '''', '') +
> > isnull(', @.provider=''' + nullif(providername, '')+ '''', '') +
> > isnull(', @.datasrc=''' + nullif(datasource, '')+ '''',
> > '')+char(10)+'go'
> > from master..sysservers
> >
> > This will help you to move the linked servers, but the security
> credentials
> > you need to define manually.
> >
> > Thanks
> > Hari
> > MCDBA
> >
> > "Chieko Kuroda" <ckuroda@.unch.unc.edu> wrote in message
> > news:#o#bX8uTEHA.1244@.TK2MSFTNGP10.phx.gbl...
> > > Hello everyone,
> > > I'd like to learn how I should go about moving my linked servers from
on
> > sql
> > > server to another sql server. Has anyone done this before?
> > > Thanks
> > > Chieko
> > >
> > >
> >
> >
>

migrate linked servers

Hello everyone,
I'd like to learn how I should go about moving my linked servers from on sql
server to another sql server. Has anyone done this before?
Thanks
ChiekoHi,
Execute the script in query analyzer with text output and copy the result to
destination server and execute it.
(Script from old post)
select 'exec sp_addlinkedserver @.server=''' + srvname + '''' +
isnull(', @.srvproduct=''' + nullif(srvproduct, '')+ '''', '') +
isnull(', @.provider=''' + nullif(providername, '')+ '''', '') +
isnull(', @.datasrc=''' + nullif(datasource, '')+ '''',
'')+char(10)+'go'
from master..sysservers
This will help you to move the linked servers, but the security credentials
you need to define manually.
Thanks
Hari
MCDBA
"Chieko Kuroda" <ckuroda@.unch.unc.edu> wrote in message
news:#o#bX8uTEHA.1244@.TK2MSFTNGP10.phx.gbl...
> Hello everyone,
> I'd like to learn how I should go about moving my linked servers from on
sql
> server to another sql server. Has anyone done this before?
> Thanks
> Chieko
>|||Thanks, I figure out that if I backed up the master database on the old
server and restored it on the new server the linked servers were add during
the restore process.
Chieko
"Hari Prasad" <hari_prasad_k@.hotmail.com> wrote in message
news:eDRLL3vTEHA.504@.TK2MSFTNGP11.phx.gbl...
> Hi,
>
> Execute the script in query analyzer with text output and copy the result
to
> destination server and execute it.
> (Script from old post)
> select 'exec sp_addlinkedserver @.server=''' + srvname + '''' +
> isnull(', @.srvproduct=''' + nullif(srvproduct, '')+ '''', '') +
> isnull(', @.provider=''' + nullif(providername, '')+ '''', '') +
> isnull(', @.datasrc=''' + nullif(datasource, '')+ '''',
> '')+char(10)+'go'
> from master..sysservers
> This will help you to move the linked servers, but the security
credentials
> you need to define manually.
> Thanks
> Hari
> MCDBA
> "Chieko Kuroda" <ckuroda@.unch.unc.edu> wrote in message
> news:#o#bX8uTEHA.1244@.TK2MSFTNGP10.phx.gbl...
> sql
>|||Hi,
OK, That is also a approch. I was under the impression that you just need to
move Linked servers only.
If you restore the Master database, it will load all logins, databases,
configurations,....If
your destination server is of same configuration as source then your
solution will work well.
If the configurations is different then the restore will cause the database
to go to suspect status and
might cause the service startup failure.
Since it works fine, no need to worry.
Thanks
Hari
MCDBA
"Chieko Kuroda" <ckuroda@.unch.unc.edu> wrote in message
news:u#D4GAxTEHA.156@.TK2MSFTNGP12.phx.gbl...
> Thanks, I figure out that if I backed up the master database on the old
> server and restored it on the new server the linked servers were add
during
> the restore process.
> Chieko
> "Hari Prasad" <hari_prasad_k@.hotmail.com> wrote in message
> news:eDRLL3vTEHA.504@.TK2MSFTNGP11.phx.gbl...
result[vbcol=seagreen]
> to
> credentials
on[vbcol=seagreen]
>

Microsoft SQL Server Management Express...help

Hi,

im trying to learn SQL Server Management Express

know a good place to start?

Im trying to upload an sql database from Visual Web Developer

Ive been told that this can be done using SQL Server manegement express...

cant see how to import into it yet... any ideas?

With Express you won't be able to upload it directly. What you'll have to do is script the database, then run the script on the production server. This will not keep the data around though. "Script Database as Create to", when you right click on the database. The "real" version of the tool (as opposed to Express) has more features.

If you want to deploy a database, try this (I haven't tried it, but it looks promising)

http://forums.asp.net/thread/1431636.aspx

|||Hi~ What do you mean by 'Upload", if you need the data, you can attach the database files (.mdf and .ldf) in Management Studio. Open it -> Right click on 'Databases' -> Attach...