Tagged Questions
-2
votes
0answers
34 views
Searching for the best Database solution [closed]
I am new to this field and trying to learn the best possible way to maintain a database for my company. I am looking for the best option (cheap and reliable) to manage all the documents and contacts.
...
0
votes
1answer
76 views
MySQL stopped working - Error 2002 - Unknown Instance
MySQL server was installed and was running just fine. Today we can't connect to the database via our websites. Command line access using mysql -u username -p also fails. Finally, phpmyadmin fails. ...
0
votes
2answers
67 views
Coverting MySQL SQL statements to SQL Server
I am installing a product which needs a database - it can use any database as long as there is a jdbc connector available for it. However, the installation guide has instructions only on how to make ...
-2
votes
1answer
78 views
Database synchronization [closed]
What is the most efficient way to sync/mirror certain data from a large remote database with a local version?
The scenario is, there is a central remote database on a hosted server, which will share ...
-3
votes
1answer
60 views
Which is easier to configure Replication for: MySql 5.5 CE vs SQL Server 2008r2 Express? [closed]
As the question states, which server is easiest to setup replication for?
My needs are:
A local master and a remote (VPN connected) slave.
I am no where near expert in either database so which ...
0
votes
1answer
595 views
MySQL ADO.NET Connector & MSSQL Integration Services
Here I am, day three... attempting to sync a data view on a Windows Vista box (64 bit) running MSSQL 2012 and Visual Studio 2010. Sanity is slipping and hunger for progress fills my attention.
I ...
0
votes
0answers
158 views
Using SSIS to Replicate a MSSQL Dataview to MySQL
I am wondering what the best approach would be to replicate a dataview or query using SSIS 2012 on a windows machine to a MySQL database server running linux.
I installed the MySQL odbc connector ...
2
votes
2answers
71 views
Run a MySQL server in a self-contained folder
I've seen many questions about how to run multiple sql servers on one server, but I would like to run mysqld as a user-level process and completely self contained in a folder (I have no permissions ...
0
votes
1answer
55 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 ...
1
vote
2answers
293 views
Possible to regularly export MS-SQL tables to another DB format on Linux without complete dumps?
We have a production server running SQL-Server, which holds our backend data, e.g., customer information, sales invoices etc. The nature of this data is that "old" data can change, e.g., a customer ...
0
votes
0answers
98 views
Schedule replication of MSSQL Views to MySQL Remote database
I have a Microsoft SQL Server 2005 Database inhouse i've to publish some information on the internet and i can't (for security policy) query this database from the web server.
So i come up with the ...
1
vote
2answers
307 views
Mysql server high trafic makes websites really slow or unable to load
Lately we have been having a lot of problems with our mysql server, from websites being really slow or even unable to load them at all. The server is a dedicated server that only runs our mysql ...
0
votes
1answer
129 views
Dedicated database server or local database server for performance
We have a dedicated server that contains 3 virtual server with iis 7.5 on it. There are 50 real ip addresses pointing to the server, with some of them assigned to the virtual servers.
I wasn't sure ...
0
votes
1answer
133 views
using command line to extract large db file
I have a large database file (1.5GB) named file.sql, I use "source" command to extract it into mysql databse but I receive lots of error messages. It used to work fine.
Here is a snapshot of part of ...
0
votes
1answer
74 views
Client to use the slave when the master is down in MySQL replication
Is it possible for the client to use the slave when the master is down in mysql replication?
I have already set up a simple MySQL replication having a master and a slave.
The client connects to the ...
0
votes
1answer
206 views
How to load a MSSQL DB using MySQL in Ubuntu
I have a MSSQL DB, and would like to convert it to a MySQL DB so I could browse it from Ubuntu. What packages/tools do I need to install and what are the steps for achieving this? Thanks
0
votes
1answer
60 views
Performance analytics via DBMS “plugins”, or other solution
I'm working on a systems monitoring product that currently focuses on performance at the system level. We're expanding out to monitoring database systems. Right now we can fetch simple performance ...
0
votes
1answer
137 views
Convert MYSQL DATABASE TO MSSQL DATABASE [closed]
I would like to ask if there is a software that convert all my database from mysql to mssql 2008
0
votes
2answers
351 views
What is the MySQL equivalent of MS-SQL's .mdf and .ldf file extensions?
I need to submit a new server request to my server management group to create a MySQL server. One of the fields required is to list file extensions which need to be excluded during commvault backups. ...
2
votes
2answers
250 views
Linking databases securely through firewall, MSSQL to MySQL
I am currently in discussions with DBA and IT Security staff within my company, and am being told that the only way to securely link to our master database (MSSQL behind a firewall) to our web apps is ...
5
votes
4answers
2k views
Why “Begin Transaction” before “Insert Query” locks the entire table?
I wrote a stored procedure to insert a record. I added "Begin Transaction" just above the Insert Query and execute the query. I noticed that another application that was showing a web page with ...
4
votes
4answers
1k views
How to create a SQL Server database from a mysqldump file automatically on a daily basis?
Recently, a vendor announced that they were upgrading their processes, and an automated, daily data dump we are getting from them will now come in a MySQL datadump format. Unfortunately, we're a ...
2
votes
1answer
345 views
error setting up replication from mssql to mysql
I'm trying to setup replication from SQL Server 2005 to MySql 5.1.53. I am able to add the publication without any problem. However, when I go to add the subscription I get this error:
OLE DB or ...
0
votes
4answers
545 views
SQL server Vs MySql vs Oracle for a large government project [closed]
I am in charge of deciding which database to use for a big government project with:
100 Million records (estimated in one big table)
Availability and data reliability is paramount.
Performance not ...
2
votes
2answers
153 views
Is it considered a bad idea to have a publicly facing MySQL or SQLServer Database?
If I wanted to create a publicly facing database for purposes of connecting it to a client MS Word or Open Office Writer installation, would this be considered a dangerous security practice? What if ...
2
votes
2answers
282 views
Transfering BLOBS on a MSSQL -> MySQL Linked Server
Working on setting up a new MySQL database for a website, and I'm trying to figure out how to transfer over long strings.
I have quite a few MSSQL tables that have Varchars ranging from 500 to 2000.
...
0
votes
1answer
273 views
Linked server to MSSQL from MySQL
We are working on setting up a linux server with MySQL on it as a testing server. I got a linked server set up on our current MSSql server so that we can query the MySQL server, but I would also like ...
2
votes
1answer
192 views
Full, Differential and Log backups of databases, MSSQL an MYSQL
Best I give a back story so you get the full picture.
I am in the process of setting up a new business, which hopefully will start in April 2012, and as such I am preparing every aspect of it. One ...
1
vote
2answers
287 views
High Transaction System Recommendations [closed]
I am a SQL Server database administrator and developer and I also have many years experience as an application developer. I currently have a customer with a very big project who is looking to me for ...
0
votes
1answer
37 views
Inconsistent MySQL performance on imports
[Process:]
Importing delimited text files from a Windows based server to a MySQL 5.1.41 instance (multiple databases) on a single Ubuntu 10.04.2 host.
The process is initiated on the Windows server ...
0
votes
1answer
89 views
The purpose of mysql_secure_installation
Whenever I used to setup a server, I'd run:
mysql -u root
# Set the root user password for all local domains
SET PASSWORD FOR 'root'@'localhost' = PASSWORD('my_password');
SET PASSWORD FOR ...
1
vote
2answers
100 views
how to scale a web application - common patterns
consider iis and mssql on one hand and apache and mysql on another. is it the same tactic when scaling iis and apache?
i got the basic scaling thing - separate web tier and db tier, and then db ...
0
votes
3answers
317 views
server upgrade from mysql What do you think
Curious to get feedback on a server selection. the system will run mysql server, with roughly 80 machines accessing the server at all times (except night)
> PowerEdge R610 Chassis for Up to Six ...
0
votes
1answer
243 views
Converting a .bak MSSQL file
I have a MSSQL 2008 .bak file from a database that I need to migrate to MySQL. Is there some way to do this without having to install Window$ and SQL Server there ?
Other options would be to do the ...
0
votes
1answer
46 views
How can I link to a database server from another server?
I'm going to launch a website in a few days, and I'm thinking of having one front-end server, and one MySQL database server. And my question is, if I want to read/write to the MySQL server from the ...
-1
votes
2answers
203 views
Does MS SQL Server requires more RAM memory than MySQL? [closed]
I had a talk with a professional who works in a hosting company and he told me that MS SQL Server does take more memory than MySQL in performing its queries. Is that true? And why do you think is the ...
0
votes
2answers
338 views
Do I need to buy Mysql cluster enterprise edition? [duplicate]
Possible Duplicate:
Can you help me with my software licensing question?
we have a ms-sql 2008 standard edition. The db became too huge, about 8 10^9 records.the db files are about 4.5tb ...
1
vote
4answers
93 views
Database security
What aspects should be considered in order to have a secure database?
Along with avoiding sqlInjection, what else should be considered? What should not be done?
1
vote
2answers
72 views
MySQL for SQL Server DBAs
I've been tasked with taking over the administration of a MySQL installation (running on Red Hat Linux) that will become fairly critical to our business in the near future.
I was wondering if ...
0
votes
1answer
484 views
Connecting to SQL Server with PHP on Mac
I'm trying to connect to my local SQL Server 2008 R2 (have also tried it with 2005, same result exactly) with PHP. I'm using PHP 5.1 which still supports php_mssql and mssql_connect().
for some ...
2
votes
1answer
676 views
Can I replicate data between mySQL and SQL Server/SQL Azure?
I have a replicated mySQL setup running happily on Amazon AWS, making user data available locally in various regions. Now I'm faced with an app that needs to go up on Microsoft Azure and I need to ...
0
votes
5answers
3k views
What are the most popular database vendors based on market share? [closed]
I am wondering if anyone can point me to research or a link to statistics regarding popularity of database deployment. Obviously, MySQL, Oracle, SQLServer are some of the major players but I am ...
3
votes
1answer
937 views
One way replication from MSSQL2005 to MYSQL 5.x
I have a mysql database acting as our websever backend. We have our production mssql server that we would like data pushed from, to our mysql server.
I have successfully made the mysql server an ...
1
vote
2answers
217 views
How do I Migrate from SQL Server 2000 to MySQL
I am looking for a way to export data from our PRODUCTION SQL Server 2000 so I can import it into a MySQL server I setup for testing.
I tried having the server generate an SQL script from the ...
0
votes
1answer
70 views
How to migrate a MySql database to a SQL Server database safely?
I have a MySql database (tables + data) I wish to move to a Sql Server 2005 database keeping data intact (I know there will be some minor differences in data types).
I'm looking for any tutorial, ...
1
vote
4answers
474 views
Best Software For Automated Database Backup (MySQL and MSSQL) [closed]
What is the best software that can backup mysql and ms sql databases automatically?
Thanks
0
votes
1answer
179 views
long dataset of small rows — infrequent writes, very frequent reads — what's the best platform?
A part of the platform I am building requires a large data table (starting at tens of millions of records, scaling to hundreds of millions within a year or two, maybe reaching billions at some point). ...
1
vote
2answers
202 views
Centralized Database Backup Server
We have database servers running on MySQL and Microsoft SQL. Is there a software that can do automated backups to all our database servers?
I've already evaluated zrm of mysql(no web access,hard to ...
2
votes
3answers
140 views
Does the order of creating a columns for a table impact performance?
For purely asthetic reasons I've always had the first column(s) of a table as the primary key column(s). After that I've not taken any care to the order columns are added to the table. Is this wrong?
...
0
votes
1answer
159 views
What is the best way to detect how/where server latency occurs?
I'm managing a small social media site, and its been for the past few days experiencing intermittent server lags. The site will choke loading a page, and moments later, the same page will have no ...
