DrAske
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?
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?
ASKER
I've uploaded the .xml files and the generated scripts from DBDesigner:
https://filedb.experts-exchange.com/incoming/ee-stuff/4254-docs.zip
https://filedb.experts-exchange.com/incoming/ee-stuff/4254-docs.zip
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
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
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
ASKER
Thank you so much :o)
really appreciate your help,
Regards,
really appreciate your help,
Regards,
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
I opened a new thread for that:
https://www.experts-exchange.com/questions/22742027/DBDesigner-4-to-MSSQL-2000.html
ASKER