mysql « SQLserver « Java Database Q&A





1. SQL Server To MY SQL    stackoverflow.com

I got a new project from my teacher to convert database to another. How can I convert a MS SQL database into MYSQL using JAVA

2. Java switch from MS SQL to MySQL - Character sets    stackoverflow.com

I am developing an application connecting to a database in Java. The customer has SQL Server and I tried the SQLExpress version von Microsoft as long as we don't want to ...

3. Should there be 2 datatables for a Parent and Child class in Java?    stackoverflow.com

I have two classes Parent and Child.

class Child extends Parent {
    private String extraField1;
    private String extraField2;
    ...
}
Child class has 2 extra ...

4. SQL Server Indexes    stackoverflow.com

I was a MySQL user. Now I'm migrating to SQL Server. But I have a problem. I can not find any way for specifiying the kind of index a table has. ...

5. Java MS SQL -> mySQL conversion    stackoverflow.com

I am building an application at work and need some advice. I have a somewhat unique problem in which I need to gather data housed in a MS SQL Server, ...

6. Java MS SQL -> mySQL conversion    stackoverflow.com

I have built a Java application that transfers data from a MSSQL db to a mySQL DB. The problem I have is that the MSSQL db constantly goes down and ...

7. connecting to a different database engine depending on user input    stackoverflow.com

I want the user to specify the name of database and table (eg database login and table customer). Once the user gives these details, the data in the table customer must ...

8. What logic is recommended to put in Stored procedures?    stackoverflow.com

I see the advantages of running code in the database engine instead of distributing this out of the database and the advantage of the opposite aswell. But the real question for me ...

9. Using XA transaction with JDBC, MySQL, and Microsoft SQL Server    stackoverflow.com

Suppose I have MySQL server running on one machine, a Microsoft SQL Server running on a second machine, and my own custom Java database running on a third machine. How do I ...





10. Can this be done in SQL? - I can do it in JAVA - Calculate Waitlists    stackoverflow.com

I am developing some hardcoded reports from embedded Java code to Crystal Reports there is a function that calculates "waitlists" My Datamodel is as follows (I've left out all of the columns and ...

11. select and delete a record without the information of primary key    stackoverflow.com

My requirement is to select a record first (the record may not have a primary key) and the delete the same record. Below is the flow :

  1. Select all records from table.
  2. while (resultset.next()), ...

12. How to Copy Data (Rows) of Sql Server into MySql in Real-time Using Java Code?    stackoverflow.com

I have one GPS tracker device whose data are inserted into Sql Server by Default but problem is I want to create Database in MySql .. So give suggesttion about how to ...

13. SQL stored procedures VS external language procedures    stackoverflow.com

I would like to know what are benefits and what are drawbacks of SQL stored procedures and procedures written on some common programming language, more precisely, which method is preferred in ...

14. JDBC: MySQL vs. SQL Server?    coderanch.com

Yes and No. MySQL, with the exception of specialized functions, adheres strictly to ANSI SQL. So no problems there. MS SQL should adhere to ANSI SQL, and when you say the MS SQL version of that statement is different, I would say that it should still work. However, MS SQL also uses a query language called TSQL (Trasact SQL). So there ...

15. changing from MSSQL to MySQL    coderanch.com

Im switching from MSSQL to MySQL. This is my first time using MySQL. I have to create tables.. stored procedures. However everything I try to copy from MSSQl come up with errors. Can someone point out what is wrong with this stored procedure? What are some of the differences between the two databases that I should keep in mind CREATE PROCEDURE ...

16. sql script works in mssql but not in mysql    coderanch.com

John, Most databases (including mysql, Oracle, db2, ...) use an owner name for the schema. When you do a query, the database tries to run the query on the schema for the id running. There are two ways to execute the query: 1) Use a fully qualified name (with schema owner) in your query directly. 2) Create a synonym to map ...





18. Replication from MySql to Sql Server    coderanch.com

How does having data in two places make it more secure than having it in one? Surely it would be easier (and more secure) to port the application to the desired database platform and drop the old database? If you absolutely must to do this, you can do this with distributed transactions. Replicate the schema and all its data then for ...

19. Migrating from mysql to mssql    coderanch.com