...
image | ||||
---|---|---|---|---|
| ||||
image | ||||
---|---|---|---|---|
| ||||
Code Block |
---|
Delete from level Delete from location Delete from segment Delete from aisle_path_node Delete from travel_path_node Delete from node Delete from aisle_path Delete from travel_path Delete from TravelPathHistoryDetails Delete from TravelPathHistory Delete from NodeCache |
Code Block |
---|
exec dbo.Move_LocationData_sp @SourceDB = 'Insert Source DB Name Here', @DestDB = 'Insert Destination DB Name Here', @SourceServer = 'Insert Source Server Name or IP address Here', @DestServer = 'Insert Destination Server Name or IP address Here', @LinkedUserName = 'protrack', @LinkedUserPwd = 'protrack', @Debug = 0 |
Code Block |
---|
exec dbo.Move_Cache_sp 'Insert Source DB Name Here', 'Insert Destination DB Name Here', 'Insert Source Server Name or IP address Here', 'Insert Destination Server Name or IP address Here', 'INSERT' |
Code Block |
---|
Delete from TravelPathHistoryDetails Delete from TravelPathHistory Delete from NodeCache |
Code Block |
---|
EXEC dbo.Move_Cache_sp 'AFM_7_3_No_NodeCacheInsert Source DB Name Here', 'AFM_7_3_forHari_031110Insert Destination DB Name Here', 'tza-atm03Insert Source Server Name or IP address Here', 'tza-atm03Insert Destination Server Name or IP address Here', 'INSERT' |