Loading

export sql server database from one server to another

Manoj Mandal

8y993

i have sqlserver database in local host which has many tables with data now i want to create job to export all the data from loalhost to cloud sql server database every 1hour without duplicate value in all the table.

example

localhost server ADMINPC

cloud server 192.303.33.251

3 Replies

Know the answer? Post it — somebody with the same question will find it here.

Kapil Singh Kumawat8y ago
Hello, You can use the import/export service zo accomplish thus.
0
Nanddeep Nachan8y ago
You may use Azure Import/Export service
https://docs.microsoft.com/en-us/azure/storage/common/storage-import-export-service
+1
Sanghamitra Mohanty8y ago
Hi ,
Please Reffer the Link:-
https://www.sqlshack.com/how-to-copy-tables-from-one-database-to-another-in-sql-server/
+1