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 2053
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: taylorcarr |
last post by:
A Canon printer is a smart device known for being advanced, efficient, and reliable. It is designed for home, office, and hybrid workspace use and can also be used for a variety of purposes. However,...
|
by: ryjfgjl |
last post by:
If we have dozens or hundreds of excel to import into the database, if we use the excel import function provided by database editors such as navicat, it will be extremely tedious and time-consuming...
|
by: ryjfgjl |
last post by:
In our work, we often receive Excel tables with data in the same format. If we want to analyze these data, it can be difficult to analyze them because the data is spread across multiple Excel files...
|
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: BarryA |
last post by:
What are the essential steps and strategies outlined in the Data Structures and Algorithms (DSA) roadmap for aspiring data scientists? How can individuals effectively utilize this roadmap to progress...
|
by: nemocccc |
last post by:
hello, everyone, I want to develop a software for my android phone for daily needs, any suggestions?
|
by: Sonnysonu |
last post by:
This is the data of csv file
1 2 3
1 2 3
1 2 3
1 2 3
2 3
2 3
3
the lengths should be different i have to store the data by column-wise with in the specific length.
suppose the i have to...
|
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,...
| |