Comments by JamesB28 (Top 5 by date)

Hi David. Thanks for the two solutions . Now I see what you were talking about when you mentioned SQL management objects. I see clear now ,you gave me the motivation to go learn more about it , because I use only ADO.NET when I deal with databases.
In the first Solution in ADO.NET Code you gave the query : string query = "CREATE DATABASE YourDatabaseHere"; This gives an Empty Database without tables . Ten Could I copy all the script That I used to create my tables and their Relationships and All in following queries ? I think Its logically possible but Just to be Sure. Anyways I liked the sql management objects Part But I'm Not experimented in this . I will have more questions, Now I consider your solutions and I go to work on it .. thanks again

I appreciate ur help , tahnks !

Well I think my Question wasn't Clear . Well I will Ask it in an other way : How can I make a Copy of the structure of my database (empty database) or even a copy of this database with inserted data VIA ado.net . Because my Client will not create a new database using MS SQL Server and then provide it to my Desktop Application . I want make it programaticcaly in my application not manually . Th e question could be also : How to create a database using ADO.NET ? I hope Its clear now , thanks

Hi David , Thanks for your answer . So in this case shall I change the whole code of my application ? or just adding some imports and replacing some codes here and there ? Cause I have never used the SQL Management Objects.