Tag Info

New answers tagged

1

Mobilink can also pass schemachanges to it's replicated databases. For this, there exists the start synchronization schema change statement This looks like this: START SYNCHRONIZATION SCHEMA CHANGE FOR TABLES DBA.Sales, DBA.Products SET SCRIPT VERSION = 'version_2'; ALTER TABLE DBA.Sales ADD SUBTOTAL NUMERIC (10,2); ALTER TABLE DBA.Products ALTER ...


1

How feasible it is move the Sybase database to a different more popular platform such SQL Server or any other. Is it feasible in the first place? Very feasible and supported by the vendors (e.g. Microsoft in-case of SQL Server). I have done plenty of SybaseASE to SQL Server migrations. Best is to use SQL Server Migration Assistant (SSMA) for ...


1

For example, I have a table which contains a column whose format is BLOB. The result I would like to get is to extract the content of the BLOB into CSV files. What is the most elegant method to do this? BCP OUT will be your best choice. Make sure your database has BLOB data (Image and/or TEXT datatypes). Also, select into should be set to TRUE ...


0

You have 2 physical disks: c0t0d0 and c0t3d0 devices: historydump, isproddump , istestdump, masterdump, modeldump, prodtestdump, sybsecuritydump,sybsystemprocsdump, uniface724dump, uniface7dump => /export => disk c0t3d0 device master => /master => disk c0t0d0 device sybdbs => disk c0t0d0 device sybdbs2 => /dev/rdsk/sybdbs2 => not sure : run "ls -l ...


0

It seems that the 5GB limit is per server, so you would not be able to have multiple 5GB databases. As for migration, it should be just a matter of shutting down the Express Edition, and using the Developer Edition binaries to start your existing data server. It may be as easy as copying then RUN_[servername] file from the old ./install directory to the ...



Top 50 recent answers are included