May 6, 2009 at 8:04 am
Hi, we have some asp code right now that transfers contents of three tables from one server to another. Here is how it works right now:
if condition1 then
rsDBorigin = DBorigin("select...FROM table1..")
sql = "......" & rsDBorigin("col1")
sql = sql & rsDBorigin("col2")
set rsDBdestination = DBdestination.Execute(sql)
if conditon2 then
rsDBorigin = DBorigin("select...FROM table2..")
Do While (NOT rsDBorigin.EOF)
May 6, 2009 at 8:11 am
you can transfer the data from one server to another, using linked server, openrowset, bcp for more info see SQL BOL.
May 6, 2009 at 12:10 pm
Hi
I'm not sure what's the specific question? 😉
Greets
Flo
May 6, 2009 at 12:22 pm
KATHLEEN Y ZHANG (5/6/2009)
Hi, we have some asp code right now that transfers contents of three tables from one server to another. Here is how it works right now:if condition1 then
rsDBorigin = DBorigin("select...FROM table1..")
sql = "......" & rsDBorigin("col1")
sql = sql & rsDBorigin("col2")
set rsDBdestination = DBdestination.Execute(sql)
if conditon2 then
rsDBorigin = DBorigin("select...FROM table2..")
Do While (NOT rsDBorigin.EOF)
Is there a question?
For best practices on asking questions, please read the following article: Forum Etiquette: How to post data/code on a forum to get the best help[/url]
May 6, 2009 at 12:27 pm
DECLARE @post VARCHAR(512)
SELECT @post = 'Hi, we have some asp code right now that transfers contents of three tables from one server to another. Here is how it works right now:'
SELECT @post = REPLACE(@post, 'works', 'doesn''t work')
EXECUTE SSC.dbo.usp_CreatePost @post
:laugh:
May 6, 2009 at 1:24 pm
Sorry, this one was sent before completed by mistake. Please refer to the next one.
http://www.sqlservercentral.com/Forums/Topic711107-145-1.aspx
Viewing 6 posts - 1 through 5 (of 5 total)
You must be logged in to reply to this topic. Login to reply