SQLCMD –Copy files from Source to Dest- Using Robocopy
SQLCMD –Copy files from Source to Dest- Using Robocopy:SETVAR DATABASE UAT:SETVAR SOURCE HQDBSU01:SETVAR DESTINATION HQDBSU02:SETVAR SOURCEPATH G:\MSSQL:SETVAR COPYPATH G$\MSSQLSET NOCOUNT ONGO:CONNECT $(SOURCE)print 'Files in sourcePath'!!dir $(SourcePath)\*.*Goprint 'Files in Destination Path':CONNECT $(DESTINATION)!!dir $(SOURCEPATH)\*.*Go:CONNECT $(SOURCE)print '*** Copy database $(DATABASE) from Source server $(Source) to Destination server $(destination) ***'!!ROBOCOPY $(SOURCEPATH)\ \\$(DESTINATION)\$(COPYPATH) $(DATABASE)*.*GOprint 'Files in Destination Path':CONNECT $(DESTINATION)!!dir $(SOURCEPATH)\*.*Go:CONNECT $(SOURCE)print 'Files in Destination Path':CONNECT $(DESTINATION)!!dir $(SOURCEPATH)\*.* ................
................
In order to avoid copyright disputes, this page is only a partial summary.
To fulfill the demand for quickly locating and searching documents.
It is intelligent file search solution for home and business.
Related searches
- using robocopy in powershell
- copy files with xcopy
- how to copy from adobe to excel
- how to permanently delete files from computer
- how to delete files from windows
- copy files without folders
- xcopy copy files and folders
- copy files without directory structure
- copy files with permission
- copy files with permissions windows
- transferring files from windows 7 to 10
- transfer files from pc to pc