nav[aria-label="Primary Navigation"] { padding: 0; & ul { list-style: none; width: 100%; display: flex; flex-direction: row; justify-content: start; align-items: start; gap: 30px; padding: 0; & li { margin: 0; } & ul li { list-style: none; } } }

Migtating to a MySQL database from MSSQL

Chris Langridge

Hello,

I have created a POC for upgrading Stash and i have installed v2.12.3. It currently works fine connecting to a MSSQL DB and can browse my current data. I am looking to migrate from MSSQL to MYSQL which is all installed on the same server. But when i select the Start migration wizard in the DB field and input the current DB details i get this

The target database contains tables which will clash with Stash's tables. Please migrate to a clean, empty database. For kore information about creating a database for use with Stash, please refer to the stash documentation.

My current set up consists of

Windows 2008 R2

Java

Stash v2.12.3

MS SQL2012

MYSQL workbench 6.1 - with new empty database created

My Install directory is sepearte to my data directory and currently everything works fine.

Any advice would be appreciated

Thanks

Chris

Accepted answers

All comments

Peter Van de Voorde

Chris,

You need a completely new MYSQL scheme to import the data into (so not one you've already used to install stash).

Best regards,

Peter

Chris Langridge

Hi Peter, thanks for the quick reply. My current Stash DB is in MS SQL and not MY SQL. I'm looking to migrate to MY SQL.

Peter Van de Voorde

Hi Chris,

Did you fill in the details of your new database (MySQL) when you were executing the migration? Or did you fill in the details of your current database? (Which seems to be the case here).

Best regards,

Peter

Chris Langridge

Hi Peter,

I completed the details of my current database (MSSQL) in the migration

Thanks

Chris Langridge

Thanks this worked

Peter Van de Voorde

That's great news Chris, could you please accept my answer as the correct one?

Welcome!

It looks like you're new here. Sign in or register to get started.

Quick Links

Find more posts tagged with

bitbucket-server

bitbucket-administration