MSSQL and MySQL Tables Question

Results 1 to 2 of 2

Thread: MSSQL and MySQL Tables Question

  1. #1
    Join Date
    Dec 1969

    Default MSSQL and MySQL Tables Question

    Hi,<BR><BR>I have been given a *.sql file, I am told this sql file will create the necassary tables in MS SQL if I run it from the Query Analyzer.<BR><BR>Is it possible to do the same in MySQL with this *.sql file???<BR><BR>If not what are the options for getting the same tables set-up in MySQL.<BR><BR>Many Thanks<BR><BR>Darrell....

  2. #2
    Join Date
    Dec 1969

    Default Yes, but...

    ...almost surely there will be some SQL-SERVER-specific things in that file that MySQL won&#039;t be able to handle.<BR><BR>It&#039;s *possible* that the file might be plain vanilla enough that it would work in both DBs, but it&#039;s pretty unlikely.<BR><BR>On the other hand, armed with an editor (even notepad) and a MySQL manual and a TSQL (for SQL Server) manual, it wouldn&#039;t be too tedious a task to translate one dialect to the other.<BR><BR>

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts