hello !

previously im using asp.net 2.0 on another computer, but now i've installed Microsoft Visual Developer 2008 Express Edition which it come with asp.net 3.5

but when i opened the SQL Server Configuration Manager, there was no setup for database... i mean to add new database..

how do i transfer the database from the other to this computer? any tutorial will mean a lots. thanks

Use SSIS. From SQL Server Mgt Studio, right click the database in the object explorer, and either use copy database or export data.

SQL Server Mgt Studio? i dont think i've installed it too..

i just only have :

Microsoft SQL Server 2005 > Configuration Tools >
1. SQL Server Configuration Manager
2. SQL Server Error and Usage Reporting
3. SQL Server Surface Area Configuration

but when i entered SQL Server Configuration Manager ... i just only have this view:

SQL Server Configuration Manager (Local)
- SQL Server 2005 Services
+ SQL Server 2005 Network Configuration
+ SQL Native Client Configuration


is something missing?

thanks for the input

You're missing SSMS, the IDE and management tool for SQL Server. You can download it here.

Taking a step back - how did you make the database in the first place? You must have issued a CREATE DATABASE query along with several CREATE TABLE and INSERTs. You could always run those against your production server.

thanks john and forrest..

i've tried using Microsoft Access and Visual Web Developer 2008 Express Edition and it works fine.
but i want to use sql server as database management.

i am downloading it now. Is it free? and also Visual Web Developer 2008 Express Edition? ...

i have a problem when restoring the database using the SSMS.

the error was

TITLE: Microsoft SQL Server Management Studio Express
------------------------------

Restore failed for Server 'BORNEO-007\SQLEXPRESS'. (Microsoft.SqlServer.Express.Smo)

For help, click: http://go.microsoft.com/fwlink?ProdN...r&LinkId=20476

------------------------------
ADDITIONAL INFORMATION:

System.Data.SqlClient.SqlError: The backup set holds a backup of a database other than the existing 'SMPB' database. (Microsoft.SqlServer.Express.Smo)

For help, click: http://go.microsoft.com/fwlink?ProdN...0&LinkId=20476

------------------------------
BUTTONS:

OK
------------------------------

when i go to the page.. the result

Details ID: Source: We're sorry There is no additional information about this issue in the Error and Event Log Messages or Knowledge Base databases at this time. You can use the links in the Support area to determine whether any additional information might be available elsewhere.
Thank you for searching on this message; your search helps us identify those areas for which we need to provide more information.
Currently there are no Microsoft Knowledge Base articles available for this specific error or event message. For information about other support options you can use to find answers online, see http://support.microsoft.com/default.aspx.

what problems here.. plz help