Link to home
Start Free TrialLog in
Avatar of DrAske
DrAskeFlag for Jordan

asked on

DBDesigner 4 to MSSQL 2000

Hi experts ..

I'm trying to connect to MSSQL  2000 through DBDesigner4 to create some tables, the problem is that I couldn't connect to the database, could you please help me?
Avatar of DrAske
DrAske
Flag of Jordan image

ASKER

Actually the schema in DBDesigner is MySQL based structure, and the generated .sql script will not work in Query Analyzer, how can I convert MySQL to MSSQL??
Avatar of DrAske

ASKER

I've uploaded the .xml files and the generated scripts from DBDesigner:
https://filedb.experts-exchange.com/incoming/ee-stuff/4254-docs.zip
ASKER CERTIFIED SOLUTION
Avatar of Aneesh
Aneesh
Flag of Canada image

Link to home
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
Start Free Trial
there is no datatype to store the "DATE" along, datetime datatype stores both date and time.
Also i am not sure how many characters u wanna store in Varchar column, so i kept it as 100, you can change it if you wanna store more data
Avatar of DrAske

ASKER

Thank you so much :o)

really appreciate your help,
Regards,
Avatar of DrAske

ASKER

I've just noticed that you've only converted RecoverHistoryDB.xml file, could you please provide me with the second one??

I opened a new thread for that:

https://www.experts-exchange.com/questions/22742027/DBDesigner-4-to-MSSQL-2000.html