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 |
|
BobbyNice
Starting Member
2 Posts |
 Posted - 2004-02-16 : 10:50:05
|
Hi...I'm new using MSDE, and I have many questions to make  , I hope you can help solve some of them...First is, how do I create tables in MSDE? I don't intend to use any tool like Enterprise manager, or Access, or VB. But, is there any free tool that looks like enterprise manager, where i can create my free databases and tables?Other question is, if I create my tables with enterprise manager, how do I transfer them to another computer that only has MSDE. Is that possible? transfer all the information, database, tables and triggers?And finaly, I have a last question. I pretend to connect 4 computers to a server. This server will have all the databases. Now, is this possible to make, without using SQL SERVER, whithout having the SQL server service manager installed?I hope you can give me some answers to solve my problemsBest regards, Gonçalo Almeida |
|
|
Doug G
Constraint Violating Yak Guru
331 Posts |
Posted - 2004-02-19 : 14:37:35
|
| MSDE provides a command line tool osql.exeThere are a number of db management tools, some free, some not free. Try searching the web. One free asp-based tool is table editor from www.2enetworx.comYou normally can use DTS to copy all database objects from one server to another. Or you can detach a database, copy the file to another server, and re-attach the database file in the new location. The servers probably need the same sql version for this to work. Or you can do a sql backup from one server and restore it to the other server.Yes to your last question.======Doug G====== |
 |
|
|
|
|
|
|
|
MSDE