Tuesday, March 14, 2017

Cross Platform dump in sybase

Cross platform dump
http://www.sybase.com/content/1033627/18XPDL_1253_WP.pdf
after you run the code dump the database and copy to the location once you have done
this you can then load the database.
Sample of code to run
USE master
go
EXEC sp_dboption 'db','single user',true
go
USE master
go
EXEC sp_dboption  'db','dbo use only',true
go
USE cats_tky_dev1
go
CHECKPOINT
go
sp_flushstats
go
sp_flushstats
go
USE master
go
EXEC sp_dboption 'db','single user',false
go
USE master
go
EXEC sp_dboption'db','dbo use only',false
go
USE db
go
CHECKPOINT
go
sp_flushstats
go
sp_flushstats
go
USE master
go
USE master
go
EXEC sp_dboption 'db2','single user',true
go
USE master
go
EXEC sp_dboption 'db2','dbo use only',true
go
USE db2
go
CHECKPOINT
go
sp_flushstats
go
sp_flushstats
go
USE master
go
EXEC sp_dboption 'db2','single user',false
go
USE master
go
EXEC sp_dboption 'db2','dbo use only',false
go
USE db2
go
CHECKPOINT
go
sp_flushstats
go
sp_flushstats
go
USE master
go

No comments:

Post a Comment