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 problems
Best 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.exe
There 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.com
You 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