How to develop database locally and post to web host?

I have MSSQL 2005 Express installed locally. I've developed a database and
would like to copy it to my web host to be accessed using some ASP code.
Everything appears to be OK, except for one issue that I can't figure out.
HOW do I take my local database and upload it to my host?
I do have the MS SQL Server 2005 Express Manager installed and can connect
to both my local SQL 2005 server and my hosts SQL 2003 server.
How are databases normally developed for web applications?Hi,
"SQL 2003 server." There is no SQL 2003 Server. If your hoster doesn=B4t
offer you to restore backups you ade on your test system. You can
either use scripts changing your database which can be applied on the
server, or you can transfer objects to your hosters db. I am alqys
doing a whole *backup* (with transfering the database objects to my
local machine) doing changes and reapply them on the *productional*
server.
HTH, Jens Suessmeyer.
http://www.sqlserver2005.de
--|||You can backup local database and restore on the host database.
If you developed database file using Visual Studio, you can attach database
on the host.
And can modifiy connection string.
"Noozer"?? ??? ??:

> I have MSSQL 2005 Express installed locally. I've developed a database and
> would like to copy it to my web host to be accessed using some ASP code.
> Everything appears to be OK, except for one issue that I can't figure out.
> HOW do I take my local database and upload it to my host?
> I do have the MS SQL Server 2005 Express Manager installed and can connect
> to both my local SQL 2005 server and my hosts SQL 2003 server.
> How are databases normally developed for web applications?
>
>

How to develop database locally and post to web host?

I have MSSQL 2005 Express installed locally. I've developed a database and
would like to copy it to my web host to be accessed using some ASP code.
Everything appears to be OK, except for one issue that I can't figure out.
HOW do I take my local database and upload it to my host?
I do have the MS SQL Server 2005 Express Manager installed and can connect
to both my local SQL 2005 server and my hosts SQL 2003 server.
How are databases normally developed for web applications?
Hi,
"SQL 2003 server." There is no SQL 2003 Server. If your hoster doesn=B4t
offer you to restore backups you ade on your test system. You can
either use scripts changing your database which can be applied on the
server, or you can transfer objects to your hosters db. I am alqys
doing a whole *backup* (with transfering the database objects to my
local machine) doing changes and reapply them on the *productional*
server.
HTH, Jens Suessmeyer.
http://www.sqlserver2005.de
|||You can backup local database and restore on the host database.
If you developed database file using Visual Studio, you can attach database
on the host.
And can modifiy connection string.
"Noozer"?? ??? ??:

> I have MSSQL 2005 Express installed locally. I've developed a database and
> would like to copy it to my web host to be accessed using some ASP code.
> Everything appears to be OK, except for one issue that I can't figure out.
> HOW do I take my local database and upload it to my host?
> I do have the MS SQL Server 2005 Express Manager installed and can connect
> to both my local SQL 2005 server and my hosts SQL 2003 server.
> How are databases normally developed for web applications?
>
>

How to determine what components are installed for SQL 2005 Express

We have serveral app groups that have installed SQL 2005 Express, but each group have installed different components. How can I determine, specifically if the following components were previously installed.

ADDLOCAL=SQL_Engine
ADDLOCAL=SQL_FullText
ADDLOCAL=RS_Server

And if not installed re-install with the missing component?

Thanks

Tony Z

There are two approaches you can check.

1. You can go Control Panel --> Add/Remove Program. Select the SQL Express entry and choose Update. Then you can see the components installed.

2. On x86 machine, check the regsigry key HKEY_LOCAL_MACHINE\SOFTWARE\Microsoft\Microsoft SQL Server\MSSQL.1\Setup : FeatureList

On x64 machine, check the corresponding WOW registry key.

how to determine sql version info

This info is from mss management studio express. how can i determine if SP2 is installed?

Microsoft SQL Server Management Studio Express 9.00.3042.00
Microsoft Data Access Components (MDAC) 6.0.6000.16386 (vista_rtm.061101-2205)
Microsoft MSXML 3.0 6.0
Microsoft Internet Explorer 7.0.6000.16448
Microsoft .NET Framework 2.0.50727.312
Operating System 6.0.6000

Hi there,

I believe that the following article should be able to help you: http://support.microsoft.com/default.aspx/kb/321185

How to determine MSDE or SQL 2005 Express vs. SQL 2000 or SQL 2005

Hi all,
I need to determine if MSDE or SQL 2005 Express is installed versus the
full version of SQL 2000 or SQL 2005. I only want my installation to
run if the full versions of SQL is installed. Where can I find this
information? Is it in the registry, can I do a SQL query that tells me
this info?
Basically I need a way of distinguishing between the free and full
versions. Any help would greatly be appreciated. Thanks in advance.
Hi,
Sorry, I should've been more clear. This is for an installation
package, so I want the install package to check the version of SQL on a
user's machine. It would need to query the database or check a
registry key, or file version, etc.
If I did select @.@.version would this say it's MSDE ot SQL 2005 Express?
I just found something that I'm not sure will work or not:
SELECT SERVERPROPERTY ('edition')
It looks like it will return either
Personal Edition
or
Standard Edition
depending on what you have (I assume Enterprise Edition as well).
Is this enough to determine whether or not it is MSDE (and SQL 2005
Express) or a full install?
Thanks.
Tom wrote:[vbcol=seagreen]
> If you use the SQL Server Mgt Studio, you right click on the registered
> server and one of the general properties is the 'Product' name, which states
> that it is SQL Server Express or SQL Server Developer etc.
>
> "Flash08" <stuart.karp@.gmail.com> wrote in message
> news:1168982219.854052.130750@.q2g2000cwa.googlegro ups.com...
|||SERVERPROPERTY is probably the safest thing to use. The possible return
values are listed here:
http://msdn2.microsoft.com/en-us/library/ms174396.aspx
This posting is provided "AS IS" with no warranties, and confers no rights.
Use of included script samples are subject to the terms specified at
http://www.microsoft.com/info/cpyright.htm
"Flash08" <stuart.karp@.gmail.com> wrote in message
news:1168988743.254141.202070@.m58g2000cwm.googlegr oups.com...
> Hi,
> Sorry, I should've been more clear. This is for an installation
> package, so I want the install package to check the version of SQL on a
> user's machine. It would need to query the database or check a
> registry key, or file version, etc.
> If I did select @.@.version would this say it's MSDE ot SQL 2005 Express?
> I just found something that I'm not sure will work or not:
> SELECT SERVERPROPERTY ('edition')
> It looks like it will return either
> Personal Edition
> or
> Standard Edition
> depending on what you have (I assume Enterprise Edition as well).
> Is this enough to determine whether or not it is MSDE (and SQL 2005
> Express) or a full install?
> Thanks.
>
> Tom wrote:
>
sql

How to detect SQLServer 2005

How can I detect if my computer have installed SQLServer 2005 or SQLServer
2005 Express with program like c# or VB.NNET?
Hi
If you can connect to the instance you can run a query that returns the
result of the function SERVERPROPERTY
SELECT CONVERT(varchar(40), SERVERPROPERTY('edition'));
John
"ad" wrote:

> How can I detect if my computer have installed SQLServer 2005 or SQLServer
> 2005 Express with program like c# or VB.NNET?
>
>

How to detect SQLServer 2005

How can I detect if my computer have installed SQLServer 2005 or SQLServer
2005 Express with program like c# or VB.NNET?Hi
If you can connect to the instance you can run a query that returns the
result of the function SERVERPROPERTY
SELECT CONVERT(varchar(40), SERVERPROPERTY('edition'));
John
"ad" wrote:
> How can I detect if my computer have installed SQLServer 2005 or SQLServer
> 2005 Express with program like c# or VB.NNET?
>
>sql

How to detach properly using SQL Server Express?

It’s easy to attach a database file in the connection string using AttachDbFilename. And that file gets closed when all connections to that database are closed (one might have to clear the connection pool, or set the connection to use master). The database file can now be moved or deleted. Sounds good...

...but that database still shows up in the attached databases! (select * from sysdatabases). So over time one could end up with hundreds of attached databases (especially if an application uses the attached databases like document files that users open and close frequently).

Question 1: Is there a performance hit having hundreds of attached databases?

OK, one can try to detach the database when the application is done with a specific file, using sp_detach_db after checking if other connections to that database are open (SELECT count(*) FROM master.dbo.sysprocesses WHERE dbid = DB_ID()). But that still does not detach if the application exists unexpectedly, or if one does not have a connection available anymore (e.g. during finalization when exiting the application). There should be a better way.

Question 2: Does anyone know of a good pattern on how an application should detach (preferably using a managed SqlConnection)?

Question 3: Is there a connection string property that auto-detaches when the connection is closed?

Thanks for any tips

--Ralf

Is there a performance hit having hundreds of attached databases?

Depends on how hard this databases are being used. Perhaps, it would be hard a little to navigate through them in Management Studio or other management tool, but I think it's all.

Does anyone know of a good pattern on how an application should detach (preferably using a managed SqlConnection)?

It looks strange that application attaches database everytime it connected to the server and detaches database everytime it disconneted. Imho, it's unnecessary cycle - just keep databases attached.

especially if an application uses the attached databases like document files that users open and close frequently

Sounds not good. What's the reason to have multiple databases instead of one?

|||

The reason for having multiple databases that are attached and detached frequently is that the user uses our app to open a database just like he would use Word to open a word file. We need to store data acquired from an instrument in easily movable files.

I thought this would be a typical use case for SQL Server Express.

how to detach a read only database from Sql Express

Need help

I made a mistake an attached a read only database to the server (now it is grey marked).

When I try to select this read only database in the MS SQL Server Management Studio, the server hangs up.

I removed the read only attribute from the .mdf and .ldf File and made a reboot of the server. Still the same problem.

How can I detach this read only database or how can I set the attribute to read/write (always hangs up the server, when I try to access this db)

I tried also:

alter database readOnly_dbname set read_write

or

USE master;
GO
EXEC sp_dboption 'readOnly_dbname', 'read only', 'FALSE';

Many thanks for an answer.

Kusi

Did you use sp_detachdb 'DbName' ?

Jens K. Suessmeyer

http://www.sqlserver2005.de

|||

I have the same problem. In management studio, the only thing that you can do is to make delete on the read-only database. You will have an error, but the database will be well released from SQL Server. I didn't find a way to make it back non read-only... by scripting or in the management studio.

Someone has a solution for that problem?

|||

I found a solution. The issue is related to the files security.

Be sure that the .mdf and .ldf files have the NETWORK SERVICE and the SQLServer2005MSSQLUser$YourPc$YourSqlInstanceName security users with Full Control permission checked on them.

How to Design a report in Web Developer Express

Hey All,
The title pretty much says it all, how do I design a report using Visual Studio Web Developer 2005 Express edition? I thought it would be pretty strait forward.

I have downloaded the add-in for it, called SQLServer2005_ReportAddin.msi and installed it. I know this provides me with a report viewer for my web apps, but I want to design a report, maybe deploy it to a reporting server. But thats all.

How do I do that?

I see no File -> New Report or anything.

Thanks for the help

Mark

Hi.

Ok, I believe that the programa that you downloaded install a new IDE... or something like that, Find out in your programs menu for "Microsoft SQL Server 2005" and then "SQL Server Business Intelligence Development Studio" and let me know.

|||Hi, thanks for the reply, I went to Start -> Programs -> SQL Server 2005 but there is nothing like "SQL Server Business Intelligence Development Studio" at all.

You are correct in saying that I installed a new IDE, I was under the assumption that when I installed Web Developer Express 2005, and the Sql Server Add-in I could create reports. But I cant find where to do it, or for that matter documentation for the add-in to help me.

Thanks for the help so far.

mark

How to deploye SQL 2005 Express with my application

Hello,

I have an application that uses SQL Server express. I'd like to be able to
package the SQL Server Express set up file and deploy it with my application
but all the searching I've done only tells me how to deploy SQL Server
Express manually (i.e. how to set it up yourself). I can script my set up
to see if an instance of SQL Server Express already exists but if it
doesn't, I'd like to know the best way to deploy this on the target machine
automatically.

Any help or direction would be greatly appreciated.

Thanks!
Rick
"Rico" <me@.you.comwrote in message
news:MSE8h.349364$R63.85587@.pd7urf1no...

Quote:

Originally Posted by

Hello,
>
I have an application that uses SQL Server express. I'd like to be able
to package the SQL Server Express set up file and deploy it with my
application but all the searching I've done only tells me how to deploy
SQL Server Express manually (i.e. how to set it up yourself). I can
script my set up to see if an instance of SQL Server Express already
exists but if it doesn't, I'd like to know the best way to deploy this on
the target machine automatically.
>
Any help or direction would be greatly appreciated.
>

See:

Embedding SQL Server Express in Applications
http://msdn2.microsoft.com/en-us/library/ms165660.aspx
Embedding SQL Server Express into Custom Applications
http://msdn.microsoft.com/library/d...qlexcustapp.asp
David|||Excellent! Thanks David!

Rick

"David Browne" <davidbaxterbrowne no potted meat@.hotmail.comwrote in
message news:OTgVwLYDHHA.1196@.TK2MSFTNGP02.phx.gbl...

Quote:

Originally Posted by

>
>
"Rico" <me@.you.comwrote in message
news:MSE8h.349364$R63.85587@.pd7urf1no...

Quote:

Originally Posted by

>Hello,
>>
>I have an application that uses SQL Server express. I'd like to be able
>to package the SQL Server Express set up file and deploy it with my
>application but all the searching I've done only tells me how to deploy
>SQL Server Express manually (i.e. how to set it up yourself). I can
>script my set up to see if an instance of SQL Server Express already
>exists but if it doesn't, I'd like to know the best way to deploy this on
>the target machine automatically.
>>
>Any help or direction would be greatly appreciated.
>>

>
See:
>
Embedding SQL Server Express in Applications
http://msdn2.microsoft.com/en-us/library/ms165660.aspx
>
Embedding SQL Server Express into Custom Applications
http://msdn.microsoft.com/library/d...qlexcustapp.asp
>
David

how to delete text file

hi...
how to delete text files from c drive (ex: c:\sale\300407.txt) using ms sql express edition 2005 ?
plz help me...

enable xp_cmdshell from start-- programs -- SQL Server 2005-- SQL Sserver surface Area Configuration tool -- Surface area confiugration for feature --

enable XP_Cmdshell

then run

exec xp_cmdshell 'del c:\yourfilename.txt'

Madhu

|||Be aware that if you are using Windows Authentication, the User who is accessing th e procedure will need the appropiate rights to delete the file. If you are using SQL Server authentication, it has to be the SQL Server Service account, if you don′t won′t either one, you will have to create a proxy account for the XP_CMDSHELL.

Jens K. Suessmeyer.

http://www.sqlserver2005.de
|||i'm using windows authentication. the command given still error. here the error :

c:\010407_S13103.txt
Access is denied

how about delete multiple text file from folder (exale) in drive c using ms sql express edition 2005. is using the same command?|||

its a permission problem. this user do not have permission in the folder. Jens's post already mention how to handle it. Basically, what xp_cmdshell used for is to run a shell command from SQL Platform. Delete multiple files use

xp_cmdshell del *.txt

Madhu

|||the user is admin. there should be no permission problem. but i still get the same error after i run the command above for multiple files. please be remind that i'm using ms sql express edition 2005.|||Are you using WIndows authentication for connecting to the database ?

|||yes i'm using windows authentication|||Then you either have a proxy account configured which is not able to access the file, or the user you are currently using for the connection is not allowed, or the usage of the directory (if you using Vista) is required elevation.

|||i try this command in ms sql 2005 express edition but still get the same error. here the command :

declare @.del varchar(1000)
select @.del = 'del c:\Transfer\*.TXT'
exec xp_cmdshell @.del

here the error:
c:\Transfer\010407SALE.131.TXT
Access is denied

i'm using windows authentication and using admin account. so there should be no permission problem. i already enable xp_cmdshell in SQL Server Surface Area Configuration. why this error still occur? plz help me. i'm using ms windows xp.|||Is the folder encrypted ?

Jens K. Suessmeyer.

http://www.sqlserver2005.de

|||no