Technical question?

  • Thread starter Thread starter Ian Frawley
  • Start date Start date
I

Ian Frawley

Would this require copying actual tables or selecting the contents of a
table on db and inserting into the contents of another db?
 
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,
 
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
 
perspolis said:
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.
Click to expand...
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 said:
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??
Click to expand...

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
 
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.
 
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
 
it ' some selected rows,.I'm wondering using SqlDataAdapter directly or
using WebService???
 
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??
 
Back
Top