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 |
|
rafaelbonfa
Starting Member
1 Post |
 Posted - 2007-10-05 : 07:34:14
|
| How can i create a new db to run locally on my pc using sql server.I need also to install a copy of this new db in another pc. Do i need the sql server installed in the other machine also? I am thinking to create an application in vb to play with the db. Every time i start the sql server i see the window telling to connect do database engine, may be i am wrong but with this window i can create just a db in the server? i couldn't create a db locally yet, anyone can help me? |
|
|
kathik
Starting Member
3 Posts |
Posted - 2007-10-05 : 08:39:52
|
| Wherever you want the database to be located, you will need SQL Server installed. A good option for learning is the SQL Server Express Edition which is free. If you can connect to the SQL Server and have the proper permissions you can create a database.Kathi |
 |
|
|
jackv
Master Smack Fu Yak Hacker
2179 Posts |
Posted - 2007-10-05 : 09:48:37
|
| Create the db on one server , and then do a Backup / restore onto another serverJack Vamvas--------------------Search IT jobs from multiple sources- http://www.ITjobfeed.com/SQL |
|
|
|
Lumbago
Norsk Yak Master
3271 Posts |
|
|
Kristen
Test
22859 Posts |
Posted - 2007-10-06 : 04:16:36
|
| Probably not what you want, but just in case:There is also a Developer version. This is very cheap to buy, has all the capabilities of the Enterprise Edition, but you cannot use it for production applications, only for Development (which I guess is self-evident!).SO you will get all the Client Tools etc. etc. which is a bit more of a hassle with the Express version.Express version is great once you have built your application and you just want a database on a PC that your application can connect to. That's a bit different to having a database on your PC that you can develop against.Kristen |
|
|
|
|
|
|
How can i create a db to run locally on my pc