Tagged Questions
1
vote
1answer
37 views
SQL Server-MySQL master-master replication
We are looking into setting up a master-master replicated MSSQL database and I am interested to hear of any potential pitfalls that we may run into along the way and generally any advice that you ...
0
votes
0answers
38 views
Converting data from MSSQL Server to MySQL using MySQL Workbench and preserving special characters
I am trying to convert a MSSQL Server database with collation SQL_Latin1_General_CP1_CI_AS into a MySQL database using MySQL Workbench. I can successfully complete the process without any issues being ...
0
votes
0answers
62 views
best way to copy data from MSSQL db to MYSQL DB(remote)
I currently copy data between my local SQL Server to a remote MySQL database linking in SQL and doing a data transformation task but now I'm sending lots of data it is getting very slow.
Just after ...
1
vote
2answers
133 views
How to migrate SQL Server to MySQL
I'm trying to migrate a SQL Server db to MySQL, and I'm having a tough time. I've tried:
MySQLWorkbench -- migration tool fails because my login only shows views in SQL Server, not the tables ...
1
vote
1answer
175 views
SQL Server to MySQL migration - how can I remove UCS-2 surrogate pairs in SQL Server?
I have been tasked with migrating a SQL Server 2005 database to MySQL 5.6 (these are both database servers runnig locally) and would really appreciate some help.
-------Edit - Answered-------
This ...
0
votes
1answer
93 views
sql server-percentage calculation
Sample data :
LINE_NO E_FIELD F_FIELD G_FIELD HSA_STATUS FAMILY CACHE_FAMILY Count
23053B 00000 00000 00000 S SUMMIT WER 43
23053B 00000 00000 00000 T ...
1
vote
2answers
362 views
How to import table's data in MySql from Sql Server?
I am trying to export table from SQL Server 2008 R2 TO MySql 5.5. For this I am using SQL Server Import and Export Wizard of Sql Server 2008, but it is giving this error.
Here this error may be ...
0
votes
1answer
66 views
Getting the exact edited data from a column in SQL Server
I have two Tables:
Articles(artID, artContents, artPublishDate, artCategoryID, publisherID).
ArticleUpdated(upArtID, upArtContents, upArtEditedData, upArtPublishDate, upArtCategory, ...
4
votes
1answer
115 views
Worth investing in MS SQL? [closed]
Not trying to start a war here, but I would like some thoughts.
I work for a small nonprofit that is eligible for generous charity licensing from Microsoft. I am the database/web coder and my ...
1
vote
1answer
156 views
Efficient query plan for selecting all data duplicated on several columns
The flavour in question is PostgreSQL, but it is a generic enough query pattern that your techniques for optimising against other RDBMs should help as well.
The purpose of the query is to show all ...
0
votes
1answer
90 views
MS SQL and MYSQL [closed]
I was going through some theoretical concepts about SQL based databases. One thing that I found interesting was that MySql and MS SQL are Relational-SQL-Database Management-Systems.
Since they both ...
5
votes
1answer
175 views
SQL Server / MySQL to DTD (+XML)
Is there any way I can at least export a table schema from MSSQL or MySQL to a DTD file? Also the same for the data of the tables to XML.
I am really not getting how to write DTDs, so I badly need a ...
1
vote
4answers
86 views
Transfer selected information from a SQL Server business server to a MySQL web server?
I have a SQL Server dedicated server used for business information on service users etc, and a VPN with MySQL for the main website operation. I wish to transfer some selected tables from SQL Server to ...
3
votes
2answers
205 views
Save history editable data RDBMS
I want to make application like testing system. Every question has one or many variant of answers (and one or many can be right). I apologize that tutors and students use my testing system. It means ...
3
votes
2answers
214 views
SQL ANSI JOIN precedence
I have a query that looks like this:
SELECT *
FROM TBLA A
LEFT JOIN TBLB B ON A.Col1 = B.Col2
RIGHT JOIN TBLC C ON B.Col3 = C.Col4
JOIN TBLD D ON C.Col5 = D.Col6
In which order ...
