MERGING TWO DATABASES WITH WEBSERVICES
-
Hi all, Can any one advice me on how to implement webservices in Copying one database tables in to the another one?The source and destination databases have the same table structures but different data.The also run within the same network on diffrent server. Any ideas will be much appreciated. Many thanks
-
Hi all, Can any one advice me on how to implement webservices in Copying one database tables in to the another one?The source and destination databases have the same table structures but different data.The also run within the same network on diffrent server. Any ideas will be much appreciated. Many thanks
Just pass the data in through a webservice method and copy it into the DB.
Christian Graus Driven to the arms of OSX by Vista. Read my blog to find out how I've worked around bugs in Microsoft tools and frameworks.
-
Just pass the data in through a webservice method and copy it into the DB.
Christian Graus Driven to the arms of OSX by Vista. Read my blog to find out how I've worked around bugs in Microsoft tools and frameworks.
Thank you Chris much appreciated. I have identity columns that are Unique for each table will that not be a problem in kepping the relationships that exist between tables on the destanation database. How can i copy keeping the identity keys in order between various tables. Many thanks
-
Hi all, Can any one advice me on how to implement webservices in Copying one database tables in to the another one?The source and destination databases have the same table structures but different data.The also run within the same network on diffrent server. Any ideas will be much appreciated. Many thanks
It would run faster if you just make the webservice initiate the copy, and perform the actual data transfer within a stored procedure using linked servers.
If you have knowledge, let others light their candles at it. Margaret Fuller (1810 - 1850) www.JacksonSoft.co.uk
-
It would run faster if you just make the webservice initiate the copy, and perform the actual data transfer within a stored procedure using linked servers.
If you have knowledge, let others light their candles at it. Margaret Fuller (1810 - 1850) www.JacksonSoft.co.uk
-
Hi all, Can any one advice me on how to implement webservices in Copying one database tables in to the another one?The source and destination databases have the same table structures but different data.The also run within the same network on diffrent server. Any ideas will be much appreciated. Many thanks
Hello m8 i have done this as a part of my program last year in school... My Solution is to First convert all the data from the first database into XML then You can either transfer the XML file to the other Web Service, Parse the XML create the schema and insert the data in the other database. ;) You have the option to also maybe encrypt the XML for security purposes. And what i think that is one of the advantages for this solutions is that XML is a standard that is read by many objects so this will make transfer easier. Hope this helps :) reply if this help you and take care