I have an application using sqlserver.
I want to send my data from this database to another database(again
sqlserver) in my site.
how can I send this data to my database on my site??
thanks in advance. 11 2054
Would this require copying actual tables or selecting the contents of a
table on db and inserting into the contents of another db?
"perspolis" <re*****@hotmail.com> wrote in message
news:ez**************@TK2MSFTNGP12.phx.gbl... I have an application using sqlserver. I want to send my data from this database to another database(again sqlserver) in my site. how can I send this data to my database on my site??
thanks in advance.
hi,
You need to provide us with more details, is this a one time operation?
would it be complete tables or just a few rows to get both dbs sync.ed
btw, this is a C# group, this question is more relevant to a SQL group
cheers,
--
Ignacio Machin,
ignacio.machin AT dot.state.fl.us
Florida Department Of Transportation
"perspolis" <re*****@hotmail.com> wrote in message
news:ez**************@TK2MSFTNGP12.phx.gbl... I have an application using sqlserver. I want to send my data from this database to another database(again sqlserver) in my site. how can I send this data to my database on my site??
thanks in advance.
yeah,I want to select content of one table and insert into another table
"Ian Frawley" <ye**@yeah.com> wrote in message
news:Oa**************@TK2MSFTNGP14.phx.gbl... Would this require copying actual tables or selecting the contents of a table on db and inserting into the contents of another db?
"perspolis" <re*****@hotmail.com> wrote in message news:ez**************@TK2MSFTNGP12.phx.gbl...I have an application using sqlserver. I want to send my data from this database to another database(again sqlserver) in my site. how can I send this data to my database on my site??
thanks in advance.
it ' some selected rows,.I'm wondering using SqlDataAdapter directly or
using WebService???
"Ignacio Machin ( .NET/ C# MVP )" <ignacio.machin AT dot.state.fl.us> wrote
in message news:e%****************@TK2MSFTNGP12.phx.gbl... hi,
You need to provide us with more details, is this a one time operation? would it be complete tables or just a few rows to get both dbs sync.ed
btw, this is a C# group, this question is more relevant to a SQL group
cheers,
-- Ignacio Machin, ignacio.machin AT dot.state.fl.us Florida Department Of Transportation
"perspolis" <re*****@hotmail.com> wrote in message news:ez**************@TK2MSFTNGP12.phx.gbl...I have an application using sqlserver. I want to send my data from this database to another database(again sqlserver) in my site. how can I send this data to my database on my site??
thanks in advance.
If both db's are on the same SQL Server then right a stored procedure to
copy the rows you want copied. You can refer to the objects like so:
db_name.db_owner.table_name.column_name
--
Derek Davis dd******@gmail.com
"perspolis" <re*****@hotmail.com> wrote in message
news:ez**************@TK2MSFTNGP12.phx.gbl... I have an application using sqlserver. I want to send my data from this database to another database(again sqlserver) in my site. how can I send this data to my database on my site??
thanks in advance.
perspolis wrote: I have an application using sqlserver. I want to send my data from this database to another database(again sqlserver) in my site. how can I send this data to my database on my site??
thanks in advance.
Why don't you just create a procedure that inserts the data into the
other schema and then create a job that moves the data. No fuss, no
muss. Make the database work for you.
both my databases are located in diffrent location.
I don't want to conntect to other database directly..
Can I use a WebService to transfer data from my application to my website??
"Sargon" <Ri***********@verizon.net> wrote in message
news:0KF2f.13819$wm3.12990@trnddc01... perspolis wrote: I have an application using sqlserver. I want to send my data from this database to another database(again sqlserver) in my site. how can I send this data to my database on my site??
thanks in advance. Why don't you just create a procedure that inserts the data into the other schema and then create a job that moves the data. No fuss, no muss. Make the database work for you.
"perspolis" <re*****@hotmail.com> wrote in message
news:%2****************@TK2MSFTNGP12.phx.gbl... both my databases are located in diffrent location. I don't want to conntect to other database directly.. Can I use a WebService to transfer data from my application to my website??
You could, but unless there's a reason you can't connect directly, I'd say a
DTS package or something would be much simpler!
Persopolis
Are you able to correct your time or localisation setting before you next
time sent a message to these newsgroups.
Thanks in advance.
Cor
If I connect directly I think it's a security problem.isn't it?
"Danny Tuppeny" <gr****@dannytuppeny.commmmmm> wrote in message
news:43***********************@ptn-nntp-reader02.plus.net... "perspolis" <re*****@hotmail.com> wrote in message news:%2****************@TK2MSFTNGP12.phx.gbl... both my databases are located in diffrent location. I don't want to conntect to other database directly.. Can I use a WebService to transfer data from my application to my website??
You could, but unless there's a reason you can't connect directly, I'd say a DTS package or something would be much simpler!
You can create a web service to transfer the data from one table to another
but u can also try and use the sql replication option which will do the same
but will save u alot of hard work
"Ignacio Machin ( .NET/ C# MVP )" <ignacio.machin AT dot.state.fl.us> wrote
in message news:e%****************@TK2MSFTNGP12.phx.gbl... hi,
You need to provide us with more details, is this a one time operation? would it be complete tables or just a few rows to get both dbs sync.ed
btw, this is a C# group, this question is more relevant to a SQL group
cheers,
-- Ignacio Machin, ignacio.machin AT dot.state.fl.us Florida Department Of Transportation
"perspolis" <re*****@hotmail.com> wrote in message news:ez**************@TK2MSFTNGP12.phx.gbl...I have an application using sqlserver. I want to send my data from this database to another database(again sqlserver) in my site. how can I send this data to my database on my site??
thanks in advance.
This thread has been closed and replies have been disabled. Please start a new discussion. Similar topics
by: David Winter |
last post by:
As a technical author and translator, I am highly interested in single
source/multi format publishing. Meaning: I'd like to keep manuals,
technical specifications etc. in multiple languages...
|
by: Vick |
last post by:
Hi Folks,
I'm not too sure if this is the appropriate place to ask this
question, but I'm trying to figure out what some of the main
differences between the following Job roles are on an IT...
|
by: Junpei |
last post by:
I need recommendations for a scientific app I'm making, here's what i
need, in order of importance
1) Strong/Complete 2d/3d plotting widgets for both data and functions
2) Realtime 2d-plotting
3)...
|
by: shaun.mostashari |
last post by:
Hello all, I am working on a trade study and one of the criterias is
how easy it is to get DB2 technical support from IBM. I appreciate if
you guys share your experience with me. Does DB2 have a...
|
by: Cherrish Vaidiyan |
last post by:
Frinds,
Hope everyone is doing fine.i feel pointers to be the most toughest
part in C. i have just completed learning pointers & arrays related
portions. I need to attend technical interview on...
|
by: Geoff Caplan |
last post by:
Hi folks,
The thread on injection attacks was very instructive, but seemed to
run out of steam at an interesting point. Now you guys have kindly
educated me about the real nature of the issues,...
|
by: flit |
last post by:
Hello All,
I have a hard question, every time I look for this answer its get out
from the technical domain and goes on in the moral/social domain.
First, I live in third world with bad gov., bad...
|
by: Charles Arthur |
last post by:
How do i turn on java script on a villaon, callus and itel keypad mobile phone
|
by: emmanuelkatto |
last post by:
Hi All, I am Emmanuel katto from Uganda. I want to ask what challenges you've faced while migrating a website to cloud.
Please let me know.
Thanks!
Emmanuel
|
by: nemocccc |
last post by:
hello, everyone, I want to develop a software for my android phone for daily needs, any suggestions?
|
by: Hystou |
last post by:
There are some requirements for setting up RAID:
1. The motherboard and BIOS support RAID configuration.
2. The motherboard has 2 or more available SATA protocol SSD/HDD slots (including MSATA, M.2...
|
by: marktang |
last post by:
ONU (Optical Network Unit) is one of the key components for providing high-speed Internet services. Its primary function is to act as an endpoint device located at the user's premises. However,...
|
by: Oralloy |
last post by:
Hello folks,
I am unable to find appropriate documentation on the type promotion of bit-fields when using the generalised comparison operator "<=>".
The problem is that using the GNU compilers,...
|
by: jinu1996 |
last post by:
In today's digital age, having a compelling online presence is paramount for businesses aiming to thrive in a competitive landscape. At the heart of this digital strategy lies an intricately woven...
|
by: Hystou |
last post by:
Overview:
Windows 11 and 10 have less user interface control over operating system update behaviour than previous versions of Windows. In Windows 11 and 10, there is no way to turn off the Windows...
|
by: agi2029 |
last post by:
Let's talk about the concept of autonomous AI software engineers and no-code agents. These AIs are designed to manage the entire lifecycle of a software development project—planning, coding, testing,...
| |