August 30, 2005 at 1:09 pm
I have a datamodel called movie.Er1 I want to load this into SQL server 2000 database. How should I do it from ERWIN so that I can load this on SQL server.
August 31, 2005 at 8:03 am
In ERWin...
First - Under the database Menu Choose Database Then make sure it is SQL Server 2000.
Second - Under the Tools Menu choose Forward Engineer / Schema Generation. Select the options you would like and then click the Generate button. This will prompt you to sign in to your SQL Server Database and if you are authorized will generate the tables/ views etc into your SQL Server Database.
August 31, 2005 at 8:26 am
...and just to add....
You need to ensure you are in the Physical model of the ERwin file to generate the database.
Finally, the movies.er1 data model is a terrible model if you are using it see how data modeling and ERwin work. It is poorly modeled and it has errors in it that will cause problems in generating a database. Just thought I'd warn ya.
Viewing 3 posts - 1 through 2 (of 2 total)
You must be logged in to reply to this topic. Login to reply