How do I move my database?

-

 

i using vwd 2005 express, sql 2005 express.  web hosting company supports asp 2.0 , sql server 2005, have put sql on database server, separate application server.  published "hello world" test application, but my database application failed after displaying logon page, presumably when first tried connect database.

vwd has created database within application folder (app\app_data\aspnetdb.mdf) , created configuration string in web.config: -

<add name="connectionstring" connectionstring="data source=.\sqlexpress;attachdbfilename=|datadirectory|\aspnetdb.mdf;integrated security=true;user instance=true" providername="system.data.sqlclient" />

this works fine on local development server, naturally fails when application copied web host, , database can no longer run application sub-folder.   sql 2000 problem have been simple fix.  have created database in host db server.  have backed development database, , restored target database.  have changed connect string, , have been ok.

how development database target database sql 2005 express?   can't use backup/restore, since there no backup within vwd 2005 express, , although there backup within management studio express (mse) need database mse first.  tried opening mdf file, mse wouldn't recognise this.  can't find way of exporting database - equivalent of sql 2000's dts not available within mse!!!!!!!!!     i tried installing eval. version of full management studio, install failed because "there no upgrade path".  

once that's sorted (if can sorted - may have go sql 2000), can find out write in configuration string?

thank you,   robert barnes

 robert barnes wrote:
 

<add name="connectionstring" connectionstring="data source=.\sqlexpress;attachdbfilename=|datadirectory|\aspnetdb.mdf;integrated security=true;user instance=true" providername="system.data.sqlclient" />

this works fine on local development server, naturally fails when application copied web host, , database can no longer run application sub-folder.   sql 2000 problem have been simple fix.  have created database in host db server.  have backed development database, , restored target database.  have changed connect string, , have been ok.

 

it same sql server 2005... express system using user instances develop under. can use management studio tools , attach database file server, set can database..... have database ftp hosting database server , restore database host server... last need change connection string talk server.

<add name="connectionstring" connectionstring="data source=<dbservername>;initial catalog=<databasename>;integrated security=true;user instance=true" providername="system.data.sqlclient" />

if using sql logons...

<add name="connectionstring" connectionstring="data source=<dbservername>;initial catalog=<databasename>;user=<userid>;password=<password>" providername="system.data.sqlclient" />

 



SQL Server  >  SQL Server Express



Comments

Post a Comment

Popular posts from this blog

more indexes

-
i want 2 indexes. likes can't mssql. i have example fields: school class number i want school , class in index can this: school class number 1 2 435 1 4 4535 1 5 265 2 1 8234 2 2 8493 4 3 943 4 2 493 4 6 934 but how can in sql server management studio i declare unique constraint. borrowing segio's ddl: create table dbo.orderrows ( id int identity (1, 1) not null primary key ,ordernr varchar (20) not null ,orderrow varchar (20) not null ,rowtotal decimal (11, 3) default 0 not null , constraint uq_orderrows unique (ordernr, orderrow) ); above under hood create unique index on column combination (ordernr, orderrow). tibor karaszi, sql server mvp | web | blog SQL Server  >  ...
Read more

ActiveDirectory

-
hello togehter, is possible disable bloody warning?: event id: 2887 event source: activedirectory_domainservice event type: warning event description: during previous 24 hour period clients attempted perform ldap binds either: (1) sasl (negotiate kerberos ntlm or digest) ldap bind did not request signing (integrity validation) or (2) ldap simple bind performed on cleartext (non-ssl/tls-encrypted) connection directory server not configured reject such binds.  the security of directory server can enhanced configuring server reject such binds.  for more details , information on how make configuration change server please see http://go.microsoft.com/fwlink/linkid=87923. summary information on number of these binds received within past 24 hours below. can enable additional logging log event each time client makes such bind including information on client made bind.  to please raise setting "ldap interface events" even...
Read more

Virtual Channel

-
on condition rdp decide protocoll extension necessary? use standard gdi , if there movie playing, switch dynamically window ms-rdpev video transfering? or full session send on additional ms-rdpev. , in cases host rendering , in case client rendering? thanks in advance! hi, the remote desktop protocol video redirection virtual channel extension used redirect audio/video streams terminal server terminal client . protocol specifies communication between application playing audio/video on terminal server , terminal client. regards, wilson jia this posting provided "as is" no warranties, , confers no rights. please remember click “mark answer” on post helps you, , click “unmark answer” if marked post not answer question. can beneficial other community members reading thread. ” Windows Server  >  ...
Read more