Tagged Questions
1
vote
1answer
52 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
46 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
70 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
145 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
189 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
95 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
445 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
117 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
157 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
180 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
89 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
208 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
219 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 ...
1
vote
0answers
96 views
MS SQL to MySQL Conversion
Is there a tool available that converts queries written as triggers, stored procedures and functions written in MS SQL 2008 to MySql? We switched databases and now I need to rewrite a bunch of queries ...
6
votes
2answers
978 views
For absolute performance, is SUM faster or COUNT?
This relates to counting the number of records that match a certain condition, e.g. invoice amount > $100.
I tend to prefer
COUNT(CASE WHEN invoice_amount > 100 THEN 1 END)
However, this is ...
1
vote
1answer
202 views
How to restore a MySQL file to SQL Server 2008
I have a MySQL file (apple.sql) that I need to restore to a SQL server 2008 database or at least be able to access the database through mySQL. I have created a linked server mySQL, created an empty ...
5
votes
2answers
176 views
How to determine which SQL Server user or database overuses server resources
I have a Microsoft SQL Server instance on my server with more than 100 databases and users. Sometimes, the SQL Server process use 100% of server CPU and I want to know which query/user/database is ...
1
vote
2answers
201 views
Synchronising SQL tables in two locations
have a bit of conundrum a the minute.
ANSI sql solutions please.
We have two databases located at two different geographic locations and will be using the web for all traffic between the two ...
1
vote
2answers
294 views
SQL Partioning on date, how does it work for future records?
I am setting up a new system and I would like to partition the data for speed. Basically what I would like to do is have one database with all the latest information (e.g. last 3 months). then have ...
2
votes
2answers
1k views
MySQL Workbench copies Schema, but not data, from SQL Server 2008
I need to copy/migrate a database from MSSQL (SQL Server 2008) into MySQL. I am using the MySQL Workbench kit, and work through the process of the Migration. Each respective DB user has full access, ...
1
vote
2answers
498 views
Database table data transfer between different servers using bcp.exe and mysqldump
I have 2 servers, both are exact clones of another, one is PRODUCTION live use and the other is strictly for backend DATAENTRY.
Using MSSQL on two different servers I am using the following command ...
0
votes
6answers
2k views
How to recover deleted/updated record in sql server or mysql?
I want to know that is there any way that I can can recover the deleted or updated record in the sqlserver and mysql as well?
0
votes
1answer
285 views
Converting a large SQL Server database to MySQL. Database corruption? Can't access data after transferring
I have gigabytes of tabular data stored in a SQL Server database. I've been trying to migrate it to MySQL using the Migration Toolkit from Oracle. I didn't have any mapping errors and fixed all the ...
3
votes
1answer
298 views
Best Approach for Mirroring Data from SQL Server to MySQL
I need help in regards to replicating data from a third party point-of-sale system with a SQL Server backend to a MySQL DB.
Specifically, can anyone suggest a best way to mirror data from SQL ...
-1
votes
1answer
71 views
Index Proposals
As a theoretical database question, if you are asked 'which indexes would you propose and why?' are the answers from primary, clustering and secondary index? How would we know if we should introduce ...
3
votes
1answer
173 views
Limiting database security
A number of texts signify that the most important aspects offered by a DBMS are availability, integrity and secrecy. As part of a homework assignment I have been tasked with mentioning attacks which ...
0
votes
2answers
260 views
Creating a test database from Production database (different machines & servers)
I'd like to set up a test database on a separate server. Production database is MS SQL Server and the test server is a *nix box so I'd like to have the test server running either PostgreSQL or MySQL.
...
2
votes
1answer
191 views
Schedule replication of SQL Server views to MySQL remote database
I have a Microsoft SQL Server 2005 Database inhouse I have to publish some information on the internet and I can't (for security policy) query this database from the web server.
So I came up with the ...
-1
votes
1answer
263 views
Important distinctions between DBMSs [closed]
DBA is a career I'm strongly considering after school, but my limited experience mostly involves some PL/SQL Oracle web programming, some basic PHP/MySQL web pages, and some queries in SQL Server. ...
3
votes
2answers
3k views
What to use, CASCADE DELETE rule or ON DELETE trigger for one to many constraint?
I would like to ask about how to handle this relationship. For better view I've tried to simplify and convert my situation into how I think StackOverflow question voting has (sorry if not :-)
I ...
0
votes
2answers
284 views
Commercial database systems versus open source database systems [closed]
Can anyone tell me what are the reasons for buying a commercial database system and not using an open-source free version?
The reason for my question is that:
Commercial systems cost upwards of ...
1
vote
1answer
187 views
How to propagate a grandparent relationship throughout a tree?
I've got a MySQL table with columns id and parent, wherein each row has another row as a parent, except for some special root rows with parent=0. There are no cycles or broken relations.
In order to ...
16
votes
11answers
4k views
Why aren't primary key / foreign key matches used for joins?
As far as I could find out many DBMSs (e.g. mysql, postgres, mssql) use fk and pk combinations only to constrain changes to data, but they are rarely natively used to automatically select columns to ...
2
votes
1answer
386 views
Correct SQL Server linked server connection settings to MySQL that will allow inserts
I'm in linked server hell! I've created a linked server to a remote MySQL database. I'm able to query and do updates. However when I attempt an insert I get an error:
"[MySQL][ODBC 5.1 ...
-11
votes
1answer
469 views
PLS FIND OUT THESE INTERVIEW QUESTIONS I HAVE FACED THESE QUESTIONS(PLS HELP ME PLS…) [closed]
1) what is your company backup policy?if something happend to your db how to restore it?
2)what type of clustering present used in your enviroment?
3)whis is the best replication?why?
4)if ...
2
votes
3answers
333 views
Which database is best for deeply embedded database or through C DLL?
I want a deeply embedded database. Deeply embedded means that the server is started by an application and closed by the application with no tcp/ip or 0 port. The main features of consideration are:
...
2
votes
1answer
304 views
How can I use a MySQL query in an openquery query on Microsoft SQL Server.?
I have the following query which works fine in MySQL:
DELETE sb
FROM stockbatches sb
INNER JOIN batchestodelete btd
ON sb.batch_batch = btd.batchno
AND sb.batch_part = btd.batchpart
...
8
votes
3answers
2k views
Where can I find example databases for MySQL, SQL Server and Oracle?
I want to experiment with the 3 large database management systems.
For this purpose it would be cool to have the same database (the same tables, etc.) for each of those.
Where can I find sql scripts ...
1
vote
1answer
409 views
Looking for a tool to convert between MySql, Sql Server CE, Sql Server and SQLite
Our old product supports 4 different database types for storing data:
SQLite
MySql
Sql Server CE
Sql Server
There is also an export feature, which allows to export some data and here is the ...
3
votes
2answers
336 views
How do you migrate a database from SQL Server 2008 to MySQL?
I'm just getting into MySQL, so forgive me if this is a basic question. For my application I need to migrate my database from SQL Server 2008 R2 to MySQL.
Is there any mechanism or technique or ...
0
votes
1answer
282 views
which DBMS should i go for? [closed]
I am interested in learning a DBMS. As a beginner which DBMS should i go for ?
I know few DBMS by name like Oracle,Sql Server,My Sql . How are these DBMS different from each other ?
As a beginner ...
4
votes
1answer
1k views
Whats the difference between Transaction logs and Binary logs?
Coming from a SQL Server shop, I now work with MySQL and I was curious.
What are the differences between MySQL's binary log and MSSQL's transaction log?
By the outlook thus far, it seems that there ...
20
votes
7answers
2k views
Why should I create an ID column when I can use others as key fields? [duplicate]
Possible Duplicate:
Why use an int as a lookup table's primary key?
So far, I'm accustomed to creating an ID column for every table and it is practical in a way that it makes me not ...
4
votes
4answers
5k views
MySQL vs SQL Server Express (Compare Free DBMS)
I am searching for a comparison table between MySQL and SQL Server Express.
Comparisons should include...
Usage limit
Tools (management/dev/backup/monitoring/...)
"simultaneous connection"
It's ...
7
votes
3answers
2k views
How to stress test a SQL server?
I've been tasked to stress test our MSSQL Server and MySQL Server. I would like to know if there are any tools or scripts which I could use on our current systems and the new system to compare ...
3
votes
1answer
395 views
Will {fn concat} work without issue in MySQL, SQL Server and Oracle?
According to this (quite old) article the principle behind ODBC escape sequences is that
The ODBC driver reads the escape sequence and translates it into the
DBMS-specific syntax before sending ...
4
votes
1answer
65 views
Internals of Windows-to-Windows SQL Server data transfer
This is a sort of generic question and I don't require a very specific answer, but let me ask it by describing a scenario.
You connect to a remote db in SQL Server Studio 08, and run a select * ...
6
votes
3answers
297 views
Is there a need to keep refreshing the indexes from time-to-time?
This question is common for all the database products I use, viz. SQL Server, MySQL, Oracle and PostgreSQL.
I have created a fresh database and the tables, at present, have no records. I have created ...
