Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
| Author |
Topic |
|
dwain Dibbley
Starting Member
2 Posts |
 Posted - 2006-04-23 : 07:44:15
|
| I have been passed a .sql script and can't work out how to use this to create the database and tables in sql 2000. Please can anyone help with some instructions on how to use this file? all i can find is how to create itThanksRobert |
|
|
Kristen
Test
22859 Posts |
Posted - 2006-04-23 : 08:27:35
|
| If you've got the SQL Client Tools installed you should be able to run the script in "Query Analyser"Make sure that the script refers to a database name which does NOT already exist, otherwise there is a risk that you will muck up the current database you are connected to, or some other existing database with the same name as the one in your script!Kristen |
 |
|
|
dwain Dibbley
Starting Member
2 Posts |
Posted - 2006-04-23 : 10:43:14
|
thanks for that i think that would work apart from this script is for mysql and is not working with sql server  ThanksRobert |
|
|
|
Kristen
Test
22859 Posts |
Posted - 2006-04-23 : 11:12:52
|
| I very much doubt you will be able to get a MYSQL script working to create an MS SQL database without considerable knowledge of the differences and lots of hand-editing!One option might be to point a Database Deign tool at the MYSQL database, have it devour the structure of the MYSQL database, and then ask it to generate an equivalent MS SQL script.Kristen |
|
|
|
|
|
|
.sql script use