My project need to migrate more than 2TB raw data from SybaseIQ to another Database. SybaseIQ using GBK, the target Database using UTF-8, the target database can only load from UTF-8 files. We use The Extract Options to extract data to GBK files first, then convert data into UTF-8, the converting is very slow because it's single processor only. Can anyone tell me the efficient way of extract data from SybaseIQ and convert charset and encode to UTF-8?

I would like to know if Data Migration Assistant copies system databases (master, model, msdb) into the new server.

We are migrating self hosted cassandra 3.11.6 to self hosted cassandra with k8ssandra-operator using cassandra 3.11.7. At some point of the migration we had to stop it due to other unrelated incident. After resuming it and running rebuild on all the nodes 3 nodes started rebuilding data again. For 2 remaining nodes I am getting this error: Unable to find sufficient sources for streaming range (6296969270738431410,6299853300486273791] in keyspace system_distributed System auth, traces, distributed were altered and are using NetworkTopologyStrategy with replication factors for dc1: 3 and dc2: 3. Any idea why that could happen and how can I solve this issue? Why 3 nodes are working fine and only these 2 have problems? Thank you for help!

We are planning to modernize our robust power builder /sybase application , that has around 500+ stored procedures,300+ tables. PB application produces 300+ reports, nothing but datawindows which has no PDF printing facility. We are debating whether our new modern database must be DB2 or Oracle ? Both database is legally bought and available for use with our company. Any thoughts ?

I am attempting to migrate from MariaDB to MySQL by doing a mysqldump from MariaDB and then restoring it to MySQL (mysql:latest docker container). I am getting the following error when importing into MySQL: ERROR 3822 (HY000) at line 172: Duplicate check constraint name 'CONSTRAINT_1'. If I look at the mysqldump file I can see why this is happening. All boolean columns in my database have a constraints that looks something like: CONSTRAINT CONSTRAINT_1 CHECK (bool_col_1 in (0,1)) CONSTRAINT CONSTRAINT_2 CHECK (bool_col_2 in (0,1)) CONSTRAINT CONSTRAINT_3 CHECK (bool_col_3 in (0,1)) These constraints were not explicitly created by me but implicitly by Flask-SQLAlchemy (I think). Notice how the constraint names are incremented starting with CONSTRAINT_1. Well the problem is that each table starts incrementing its constraint names starting with CONSTRAINT_1. Thus the error I am seeing gets thrown when trying to create the second table. According to the MySQL docs , duplicate constraint names are not allowed. Apparently MariaDB allows them. **Is there a way to rename these constraints systematically or an alternative way to migrate the data?** The quantity of tables prohibits manually changing the name of each constraint. Note: This fiddle tests duplicate constraint names and executes without error on MySQL. However if I run the same commands on a fresh MySQL container, it fails with the duplicate constraint.

In SQL Server 2014, dreplay.exe was available under "Management Tools – Basic" feature. However, in SQL Server 2017 that feature no longer exists (Enterprise edition) and it doesn't come with SSMS installer either. Here is what available from SQL Server 2017 installer: Did they move dreplay.exe somewhere else? Any help is much appreciated! **Update 1.** ------------- It seems there is a bit of confusion around Distributed Replay and what exactly I am looking for. So I thought to include a diagram from this article : **Administration tool** (dreplay.exe) is what I am looking for. **Controller** (DReplayController.exe) is Distributed Replay Controller from feature selection screen. It is useless without Administration tool. **Client** (DReplayClient.exe) is Distributed Replay Client from feature selection screen. It is useless without Controller. **Update 2.** ------------- OS: Windows Server 2016 Standard SQL Server Management Studio version: 18.4 ** ** (As this post suggests dreplay.exe came with SSMS 17.x, but got removed from 18.x) SQL Server version: 14.0.1000.169 *** *** (displayed at Installation Type step or can be found in MediaInfo.xml Property Id="BaselineVersion" that is located in the root of disk with SQL Server installer) Binn folder contents: Directory of C:\Program Files (x86)\Microsoft SQL Server\140\Tools\Binn 18/11/2019 15:19 . 18/11/2019 15:19 .. 18/11/2019 15:19 DQ 22/08/2017 18:39 697,528 DReplayCommon.dll 22/08/2017 18:39 20,592 DReplayServer.tlb 22/08/2017 18:40 32,952 DReplayServerPS.dll 04/11/2019 15:25 Resources 04/11/2019 15:28 schemas 15/06/2019 11:09 602,848 SqlManager.dll 22/08/2017 18:47 60,088 SQLPS.exe 22/08/2017 18:48 379 SQLPS.exe.config 15/06/2019 11:09 29,472 sqlresld.dll 15/06/2019 11:09 29,264 SqlResourceLoader.dll 15/06/2019 11:08 59,672 SQLSCM.DLL 15/06/2019 11:08 133,200 SQLSVC.DLL 10 File(s) 1,665,995 bytes 5 Dir(s) 97,550,450,688 bytes free

I have 2 VMs, both are identical in structural terms (came from the same snapshot, nothing installed, upgraded or removed). One VM is "clean", never used. The other VMs was heavily used and it has some data stored in the Postgres DB. **Is there a way to migrate the Postgres database from the heavily used VM to the clean VM just by copying the DB files from a specific folder?** For instance, let's say that Postgres (I'm assuming this part) writes all its files in the directory XYZ. If I copy all files from that XYZ directory to the clean VM, will Postgres work? I'm not worried if that is the correct way to do that or not. This is just a PoC and I need to do it with the least effort possible and copying files around seems to be the best fit here.

I am squashing migrations and rewriting all constructs like:

CREATE TABLE entities (
  id bigint GENERATED ALWAYS AS IDENTITY PRIMARY KEY,
  title text NOT NULL,
  description text
);

CREATE INDEX ON entities (title);
CREATE INDEX ON entities (description);

Into:

CREATE TABLE IF NOT EXISTS entities (
  id bigint GENERATED ALWAYS AS IDENTITY PRIMARY KEY,
  title text NOT NULL,
  description text
);

CREATE INDEX IF NOT EXISTS ON entities (title);
CREATE INDEX IF NOT EXISTS ON entities (description);

When I run the squash I get a syntax error on the CREATE INDEX IF NOT EXISTS ON entities (title); line. After squinting harder at the [docs reference](https://www.postgresql.org/docs/13/sql-createindex.html) I noticed IF NOT EXISTS does in fact require name after it.
So what is the right way to conditionally recreate "default" indexes like this?

We are doing some SQL Server migrations, various versions, by cloning (snapshot backups) the host servers to the new DC in a different domain. Work is still in planning stage, not yet implemented. For the DEV environment in the destination domain, we need to have Production data in the databases from the source instances. I am therefore thinking that we could clone the Production server from the source domain and rename the host in the destination Dev environment. The SQL server host name part of the instance name will also be renamed i.e. host_server_name\instance_name. Are there other considerations that I need to have in going down this route? Things I need to be aware of about moving from Prod to Dev? Logins/users from Prod will be dropped and test logins/users will be scripted in. Any thoughts will be appreciated please. Thank you.

I apologize if I made any mistake/missing info, fist post here! I am in the process of rewriting a website from scratch to a newer tech stack with a completely redesigned architecture. The website in question is a real estate website to rent houses for short period of times. It was designed/created in 1998-1999 and has been working ever since. A few cosmetic redesigns have been made to the website, but no changes have been made to the database or the architecture except for hosting-mandated updates to the infrastrcture (they run on one of those shared spaces). The current stack is as follows: * DB: MySQL (10.1.41-MariaDB-cll-lve) * Server: PHP 7.0 * Client (Web): Simple Bootstrap website, nothing fancy The system was originally designed by a student, which had no idea/experience with these kind of systems. The structure of the DB is quite flat, and there are just a few tables (< 5). There are almost no joins in the code, and as an example their booking periods are all put together in the same field, with the dates split by delimiters and concatenated in the format

DD:MM:YYYY-DD:MM:YYYY/DD:MM:YYYY-DD:MM:YYYY/...

So whenever they need to check for availability, they parse this string. Also, data types are scarcely used and most of the fields are strings. I have rewritten the entire system with a new architecture and schema using relations whenever possible as well as adding quite a few tables. This is the stack: * DB: PostgreSQL * Server: Spring Boot (latest) with Spring Data * Client (Web): Vue.js I now need to migrate the old data to the new system, and I am not sure how to proceed. I have thought of two different options: 1. Write a script that takes all the data from the DB, creates the relations and adapts to the new schema, and stores them in the new DB (**EDIT**: The script could also parse the dates, etc). Of course this needs to be properly tested but I am not in a time crunch. The script could be written in either Python (to allow me to manipulate the fields without having to deal with types) or using Java (being as I use Spring) and using the new models directly. 2. Extract the data from MySQL and dump it into PostgreSQL. Then, write some kind of an adapter that allows me to read the data and manipulate it little by little whenever needed. I am afraid of this option as Spring Data is quite strict at times and I would need to duplicate a lot of the models I have created. Keep in mind the following things: 1. There are about 5000 entries between all the tables, so not a huge migration. Still, they have a lot of information that needs to be accurate and cannot be lost. 2. Spring Data complains quite easily about foreign key restrictions if you touch the schema in any way (i.e. manually) and therefore I am afraid of doing all the work and then having to deactivate safety features. 3. The migration will be done only once. Once verified, we will keep a copy of the old database just to be sure but everything else will be moved to the new system. **EDIT:** As pointed out in the comments, I forgot to ask the actual question :). Are any of the options I listed a good way to approach this problem? Are there any tools out there that may help me in this migration? I think that option 1 is the best for my case, am I missing something? Any help is greatly appreciated!

First, let me say I'm not a DBA or network admin, but have moved large scale CMS websites from host to host. But, I have never moved a pure PHP-coded database driven website from one host to another. What I have done is moved the entire site including the level above 'html' with the include folder with config.php, database.php, main.php etc. I have imported database(s) and have proper credentials for access. But, when I try to load a file from the site (ex. accounts/index.html) I just get partial code returned with no css styles or anything that controls the site. Could someone point me in a direction to be able to start to sync this site back? Like I said, getting raw output with viewing files and can't even get CSS to load site colours and styles. I'm a newb when it comes to this aspect of things and appreciate any guidance.

I have a question, and I've found one similar addressed, which I was going to respond to with my own questions (https://dba.stackexchange.com/questions/335192/live-database-migration-mariadb-10-5-to-mysql-8-0) , however, as that post/question is over a year old, I thought it may be better for me to create a new question. My Situation: I have a Web server (Apache) hosted by a 3rd party. The server is currently running MariaDB 10.5. On this server we have several sites, running on the last version or two of WordPress, and sites running Drupal 8, 9, and 10. Thus far, we've had no issues. However, we want to begin development of a couple projects on the Drupal 11 platform. When attempting to install D11, we're told that it requires MariaDB 10.6. I've made contact with our hosting company, and they've said that while they won't be upgrading our current server, they are willing to migrate us to another server, and we've been given the option to move to a server running MariaDB 10.6, or a server running MySQL 8. Being 100% honest, I know how to create the databases and from there, I've just let WordPress or Drupal do what they need to do. I've had no reasons to delve deeper into the Databases (Though this is an area that I'd like to learn more about). But for this situation, I'm not sure what is the better option to choose. Of course, objective Number One, would be to not break any of the currently running websites. I **presume** that migrating from the MariaDB 10.5 server to a MariaDB 10.6 server would be a "clean" move, but admittedly, I'm not positive of that. I'm also not sure what (if any) issues would be caused (or oppositely, benefits would be gained) migrating a MariaDB 10.5 website to a MySQL 8 server. I come to this forum, seeking your wisdom and direction. Thank you.

We are migrating from Google-Cloud PGSQL managed database to a managed PGSQL server on Digital ocean. The dilemma we are facing is that both Google and Digital ocean are managed so we have no access to directories so we can't dump then restore. So how would we go about this? Is there a command that copies the data directly from Google-Cloud PGSQL to Digital ocean? Digital oceans resources assume we have access to a directory.

We are migrating an application's database between servers and we have used the Attach method to attach the database files to the new location. After re-pointing the application to the new database all operations can be performed successfully except for one, which requires a group of tables modifications. These tables are linked with KFs and have an Index. It's strange because we don't face these issues with the old database. We have checked the Triggers, FK relations, and Indexes, and it all looks similar between both DBs. Is there a hidden relationship that requires fixing? P.S.: I am a programmer, not DBA and these are the steps I have performed: 1. Copy .mdf then paste to the new server 2. Attach the .mdf to the new 3. server Repoint the application to the new IP Test the operations, 4. it's all working and can insert/update the new DB A group of 5. operations related to logically related tables are not working.

We are currently working on a project to move all of our disparate DBs (MySQL, Oracle, older versions of MS SQL) to SQL Server 2014. So far, pretty much everything has gone smoothly, however, there is one Oracle Database (10g 10.2.0.5), which we're trying to migrate using SSMA that just doesn't show up in the SSMA object explorer. I have tried connecting to this database using the schema owner, the sys AND the system users and it just never shows up. ALL the other schemas on this instance show up and we can migrate them successfully. Has anyone come across this issue before? Could anyone suggest possible reasons for this? I - and the SQL Server DBA - am stumped. In the interim, we're migrating subsets of data using smacked-together Perl scripts, but this is obviously not ideal.

We have an old MYSQL server contains huge data ~5TB and wanted to migrate to the new server in order to minimize the costs and get rid of very old hardware. My one and only idea in my mind is using mysqldump for the migration but I’m pretty sure that it’s a poor and risk option with that huge data. Then someone in my team came up with the idea for using ETL tools but we haven’t go into the deeper details and not really sure if this ETL way can literally help us. Any idea are always welcomed thanks

I have a 4 Tb SQL Server 2008 R2 database. I'm going to move this DB to a new server with a new release of SQL Server 2012. (the application does not support SQL Server > 2012, but that is not the subject of my question). Before that, I'm going to move almost all objects from the main datafile of 4To to multiple datafiles on the same filegroup so I can get back the free space on the 4Tb file. After moving objects, free space take like forever to be reclaimed with a dbcc shrink file with blocs of 256Mo. What's the fastest way to get that space back to the OS? Is there a way to use a backup restore to shrink the file?

Here are the components: WSFC Name: SQLPROD1 Existing Nodes in this "cluster": SQL2014OnSite and SQL2014OffSite New Nodes to be added (?) to SQLPROD1: SQL2016OnSite and SQL2016OffSite All 4 servers running Windows Server 2012 R2 Enterprise. All 4 instances of SQL Server are Enterprise Edition. I successfully added the two new servers to the WSFC. I successfully configured the two new SQL2016 instances to use AlwaysOn. For testing purposes, I created a new AOAG named TestMigrate with a single database, AdventureWorks2014 and configured it to be identical to the 3 production AOAGs (Asynchronous commit, manual failover and non-readable secondary). I then proceeded to add the 2 new nodes as replicas to the AG (worked great). I read this article (https://msdn.microsoft.com/en-us/library/dn178483.aspx) , in the section titled "Availability Group with One Remote Secondary Replica" that indicated it was necessary to change the Availability Mode to Synchronous Commit, then failover to the new primary node, and finally change the Availability Mode back to Asynchronous Commit. Up to this point, everything worked as expected. The problem happened when I removed the original 2 nodes from the AG. Within a few seconds, both replica copies of the database switched to "Restoring", and the AG disappeared from both 2016 instances. Is there some "background" metadata that links the AG to the instance where it was created? Also, it was my assumption that this was the best way to upgrade/migrate these AGs, but since it completely dropped the AG once I removed the two original nodes/instances, I'm guessing it's not...or I have missed a rather crucial step. I've searched high and low online for a straight-forward approach to accomplish this task, but haven't found anything that addresses this specific requirement. Several "similar" tasks, but not quite the same...and not close enough to give me the "missing piece(s)". Any suggestions or recommendations would be very much appreciated.

Is there a way to query the dB to know if pg_upgrade ran successfully and migrated the data? I want to know if a database is fresh post-installation or the data from the previous version has been migrated. The previous dB can be empty as well.

I want to recreate the table below in SQL server I have tried using SSIS but it does not know how to handle the lOV Data type how can I recreate this table in SQL server and migrate the data to it. create Table Listing ( NAME VARCHAR2(30), VALUES NUMBER, LIST_OF_VALUES LOV, id VARCHAR2(30) ); I am new at trying to converting this type of data or data type, in general, your help would be appreciated.