transfer the data from local pc to server
-
hi, i have database in the server and also having same database in another system. if i modified my data in my pc then the changes should save in the server database also. i heard, some of my friends said that u can use replication or export data..... can any one tell me with the solution
-
hi, i have database in the server and also having same database in another system. if i modified my data in my pc then the changes should save in the server database also. i heard, some of my friends said that u can use replication or export data..... can any one tell me with the solution
You need have full administration privilege on your sql server on server to user Replication. Usually with dedicated server this privilege is enough. more about replication: http://msdn.microsoft.com/en-us/library/ms151198.aspx[^] but first look at your problem: if you have a database on local and you need transfer your data to server for one time, replication is not recommended, i recommand integration service, or sql scripts , or backup and restore. but if you want to transfer every day, every week and ... i think you must use replication.
Human knowledge belongs to the world http://www.rad.pasfu.com/index.php
-
You need have full administration privilege on your sql server on server to user Replication. Usually with dedicated server this privilege is enough. more about replication: http://msdn.microsoft.com/en-us/library/ms151198.aspx[^] but first look at your problem: if you have a database on local and you need transfer your data to server for one time, replication is not recommended, i recommand integration service, or sql scripts , or backup and restore. but if you want to transfer every day, every week and ... i think you must use replication.
Human knowledge belongs to the world http://www.rad.pasfu.com/index.php
hi , i need to transfer the data every day from the pc to server database so i am using sql server 2005 express edition ... while i am gng to replication process its asking me to install replication.. can any one give the url for replication download....