November 16, 2004 at 7:09 am
How do I access a different server from SQL? Here's my command:
insert into dbname.dbo.tablename
select * from sourcedb.dbo.tablename
so how do I make that select statement access a table on a
different server?
November 16, 2004 at 7:14 am
check out "linked servers" in books online.
If this is only a one-shot event, it is best to use DTS for this kind of stuff.
You may want to read some more about these different ways of copy/replication. Each has its pros and cons .
Johan
Learn to play, play to learn !
Dont drive faster than your guardian angel can fly ...
but keeping both feet on the ground wont get you anywhere :w00t:
- How to post Performance Problems
- How to post data/code to get the best help[/url]
- How to prevent a sore throat after hours of presenting ppt
press F1 for solution, press shift+F1 for urgent solution 😀
Need a bit of Powershell? How about this
Who am I ? Sometimes this is me but most of the time this is me
November 16, 2004 at 7:19 am
I cant figure out how to do it with DTS. Actually its the DTS
packages I'm trying to move, and it wont let me select the
sysdtspackages table from the msdb database when I try to create
a package to do it.
November 16, 2004 at 7:23 am
Have a look at http://www.sqldts.com
I think there is a tool available for this.
--
Frank Kalis
Microsoft SQL Server MVP
Webmaster: http://www.insidesql.org/blogs
My blog: http://www.insidesql.org/blogs/frankkalis/[/url]
November 16, 2004 at 7:27 am
Now I got it. DTSBackup 2000.
--
Frank Kalis
Microsoft SQL Server MVP
Webmaster: http://www.insidesql.org/blogs
My blog: http://www.insidesql.org/blogs/frankkalis/[/url]
November 17, 2004 at 12:16 am
To move DTS packages I use
INSERT INTO msdb.dbo.sysdtspackages
SELECT * FROM
OPENDATASOURCE('SQLOLEDB', 'Data Source=SQL-Server;User ID=sa;Password=pwd').msdb.dbo.sysdtspackages
It works fine from SQLAgent and keeps all servers synchronized.
You might want to delete existing packages before inserting new ones.
Carsten
Viewing 6 posts - 1 through 5 (of 5 total)
You must be logged in to reply to this topic. Login to reply