Copy diagram from one MSSQL db to another

Hallo,
The subj actually says it all. I have developed the database locally, and
added a nicley formatted diagram to it, and would like to spare the
possibility to remake it once again on another database that has exactly the
same structure. So, there must be some way to copy the diagram from here to
there. I'd appreciate if someone could hint me how that could be possible to
achieve.
Thank you,
-- PavilsThe following article explains how to do it:
HOW TO: Move a Database Diagram
http://support.microsoft.com/?id=320125
-Sue
On Tue, 2 Mar 2004 16:31:13 +0200, "Pavils Jurjans"
<pavils@.mailbox.riga.lv> wrote:

>Hallo,
>The subj actually says it all. I have developed the database locally, and
>added a nicley formatted diagram to it, and would like to spare the
>possibility to remake it once again on another database that has exactly th
e
>same structure. So, there must be some way to copy the diagram from here to
>there. I'd appreciate if someone could hint me how that could be possible t
o
>achieve.
>Thank you,
>-- Pavils
>|||Thanks, that works well. Luckily, I have only one diag to copy and the
destination database does not contain any diagrams. There could be
complications using this copy *.* approach on some finer cases.
-- Pavils
"Sue Hoegemeier" <Sue_H@.nomail.please> wrote in message
news:s279401gpnvhr8892a3s1gq7rsqoi4rnpl@.
4ax.com...
> The following article explains how to do it:
> HOW TO: Move a Database Diagram
> http://support.microsoft.com/?id=320125
> -Sue
> On Tue, 2 Mar 2004 16:31:13 +0200, "Pavils Jurjans"
> <pavils@.mailbox.riga.lv> wrote:
>
the
to
to
>sqlsql

Copy diagram from one MSSQL db to another

Hallo,
The subj actually says it all. I have developed the database locally, and
added a nicley formatted diagram to it, and would like to spare the
possibility to remake it once again on another database that has exactly the
same structure. So, there must be some way to copy the diagram from here to
there. I'd appreciate if someone could hint me how that could be possible to
achieve.
Thank you,
-- PavilsThe following article explains how to do it:
HOW TO: Move a Database Diagram
http://support.microsoft.com/?id=320125
-Sue
On Tue, 2 Mar 2004 16:31:13 +0200, "Pavils Jurjans"
<pavils@.mailbox.riga.lv> wrote:
>Hallo,
>The subj actually says it all. I have developed the database locally, and
>added a nicley formatted diagram to it, and would like to spare the
>possibility to remake it once again on another database that has exactly the
>same structure. So, there must be some way to copy the diagram from here to
>there. I'd appreciate if someone could hint me how that could be possible to
>achieve.
>Thank you,
>-- Pavils
>|||Thanks, that works well. Luckily, I have only one diag to copy and the
destination database does not contain any diagrams. There could be
complications using this copy *.* approach on some finer cases.
-- Pavils
"Sue Hoegemeier" <Sue_H@.nomail.please> wrote in message
news:s279401gpnvhr8892a3s1gq7rsqoi4rnpl@.4ax.com...
> The following article explains how to do it:
> HOW TO: Move a Database Diagram
> http://support.microsoft.com/?id=320125
> -Sue
> On Tue, 2 Mar 2004 16:31:13 +0200, "Pavils Jurjans"
> <pavils@.mailbox.riga.lv> wrote:
> >Hallo,
> >
> >The subj actually says it all. I have developed the database locally, and
> >added a nicley formatted diagram to it, and would like to spare the
> >possibility to remake it once again on another database that has exactly
the
> >same structure. So, there must be some way to copy the diagram from here
to
> >there. I'd appreciate if someone could hint me how that could be possible
to
> >achieve.
> >
> >Thank you,
> >
> >-- Pavils
> >
>

Copy Database Wizard (MSSQL 2000)

Trying to copy a mssql 7 db from a NT 4.0 server to a mssql 2000 default instance on a Windows 2003 server using the Copy Database Wizard. The Wizard indicates that the database is OK to copy but that the "Files on the source have the same name as on the destination or there is not enough free disk space on the destination." Both of these statements are false. The db doesn't exsist on the destination and there is no shortage of disk space. Any help?

pse post the full error with error number and description.... BTW it is always better to use Backup/restore to transfer database ...

Madhu

copy database from one server to another

Hi:

I have a MSSQL 2005 database in current server, since we are going to shift to another server, I need to copy the database to the new server for testing.

Can you please let me know what is the best way to do that? I have tried to use detach and attach, or "back up the database and then restore on the other server.", but seems not working for me. I want step by step instruction since I am pretty new for the DB migration.

Thanks.

Jt

Hello Jt,

Do you know why the detach/attach and backup/restore are not working properly? They are created to do these kind of actions.

Have a look at the following article to move a database with attach/detach:http://support.microsoft.com/kb/224071

or to do the restore:http://msdn2.microsoft.com/en-us/library/ms186390.aspx

|||

Have a look atthis post on Scott Gu's blog, detailing the use of the recently releasedDatabase Publishing Wizard. It explains how to transfer a database schema and/or it's data to another server. It basically outputs a script file containing all the commands, which you would then save and execute on the server you wish to transfer it to.

Hope that helps.

converting to date only

I have a function on a MSSQL 2000 db like the following:

create function GetDateOnly (@.pInputDate datetime)
returns datetime
as
begin
return cast(convert(varchar(10), @.pInputDate, 111) as datetime)
end

which returns the date with the time all zeros ( '2006-05-09 00:00:00' ). I tried to implement this same function on an MSSQL 7 server and I get errors.
Server: Msg 170, Level 15, State 1, Line 1
Line 1: Incorrect syntax near 'function'.

How can I code something similar in version 7? I'm assuming it's a version difference that is causing my problems.

Thanks,
Randy7.0 did not support user-defined functions.

You could write a stored proc with an OUTPUT parameter to do this, but you could not include it in a SELECT statement as you can with a function.

You will probably need to code the logic each time you need it. But I suggest you use this formula instead, which is more efficient than the CONVERT method you are using:

create function GetDateOnly (@.pInputDate datetime)
returns datetime
as
begin
return dateadd(day, datediff(day, 0, getdate()), 0)
end|||thanks alot for the advise. I thought about stored procedure, but then like you mentioned I can't use it in a SELECT which was my whole goal. Back to the drawing board :-)

Randy

Converting SQL express 2005 to MSSQL 2005 Database

Hello, im shure this must have been up before and i apologize for that. But i wonder if there is a way to convert the SQL server express databases to MSSQL 2005 databses?

You should be able to open a SQL Express database in SQL2005.

|||

Yes but that is not what i meant, i mean that the MSSQL Express DB dont seems to be working on my webhost so i assume i need to convert the db to a MSSQL 2005 not express edition, the error i keep getting now is:

Server Errorin'/' Application.------------------------An error has occurredwhile establishing a connection to the server. When connecting to SQL Server 2005,this failure may be caused by the fact that under thedefault settings SQL Server does not allow remote connections. (provider: SQL Network Interfaces, error: 26 - Error Locating Server/Instance Specified) Description: An unhandled exception occurred during the execution of the current web request. Please review the stack tracefor more information about the error and where it originatedin the code. Exception Details: System.Data.SqlClient.SqlException: An error has occurredwhile establishing a connection to the server. When connecting to SQL Server 2005,this failure may be caused by the fact that under thedefault settings SQL Server does not allow remote connections. (provider: SQL Network Interfaces, error: 26 - Error Locating Server/Instance Specified)Source Error: An unhandled exception was generated during the execution of the current web request. Information regarding the origin and location of the exception can be identifiedusing the exception stack trace below. Stack Trace: [SqlException (0x80131904): An error has occurredwhile establishing a connection to the server. When connecting to SQL Server 2005,this failure may be caused by the fact that under thedefault settings SQL Server does not allow remote connections. (provider: SQL Network Interfaces, error: 26 - Error Locating Server/Instance Specified)] System.Data.SqlClient.SqlInternalConnection.OnError(SqlException exception, Boolean breakConnection) +734979 System.Data.SqlClient.TdsParser.ThrowExceptionAndWarning(TdsParserStateObject stateObj) +188 System.Data.SqlClient.TdsParser.Connect(Boolean& useFailoverPartner, Boolean& failoverDemandDone, String host, String failoverPartner, String protocol, SqlInternalConnectionTds connHandler, Int64 timerExpire, Boolean encrypt, Boolean trustServerCert, Boolean integratedSecurity, SqlConnection owningObject, Boolean aliasLookup) +820 System.Data.SqlClient.SqlInternalConnectionTds.OpenLoginEnlist(SqlConnection owningObject, SqlConnectionString connectionOptions, String newPassword, Boolean redirectedUserInstance) +628 System.Data.SqlClient.SqlInternalConnectionTds..ctor(DbConnectionPoolIdentity identity, SqlConnectionString connectionOptions, Object providerInfo, String newPassword, SqlConnection owningObject, Boolean redirectedUserInstance) +170 System.Data.SqlClient.SqlConnectionFactory.CreateConnection(DbConnectionOptions options, Object poolGroupProviderInfo, DbConnectionPool pool, DbConnection owningConnection) +130 System.Data.ProviderBase.DbConnectionFactory.CreatePooledConnection(DbConnection owningConnection, DbConnectionPool pool, DbConnectionOptions options) +28 System.Data.ProviderBase.DbConnectionPool.CreateObject(DbConnection owningObject) +424 System.Data.ProviderBase.DbConnectionPool.UserCreateRequest(DbConnection owningObject) +66 System.Data.ProviderBase.DbConnectionPool.GetConnection(DbConnection owningObject) +496 System.Data.ProviderBase.DbConnectionFactory.GetConnection(DbConnection owningConnection) +82 System.Data.ProviderBase.DbConnectionClosed.OpenConnection(DbConnection outerConnection, DbConnectionFactory connectionFactory) +105 System.Data.SqlClient.SqlConnection.Open() +111 System.Web.DataAccess.SqlConnectionHolder.Open(HttpContext context, Boolean revertImpersonate) +84 System.Web.DataAccess.SqlConnectionHelper.GetConnection(String connectionString, Boolean revertImpersonation) +197 System.Web.Security.SqlMembershipProvider.GetPasswordWithFormat(String username, Boolean updateLastLoginActivityDate, Int32& status, String& password, Int32& passwordFormat, String& passwordSalt, Int32& failedPasswordAttemptCount, Int32& failedPasswordAnswerAttemptCount, Boolean& isApproved, DateTime& lastLoginDate, DateTime& lastActivityDate) +1121 System.Web.Security.SqlMembershipProvider.CheckPassword(String username, String password, Boolean updateLastLoginActivityDate, Boolean failIfNotApproved, String& salt, Int32& passwordFormat) +105 System.Web.Security.SqlMembershipProvider.CheckPassword(String username, String password, Boolean updateLastLoginActivityDate, Boolean failIfNotApproved) +42 System.Web.Security.SqlMembershipProvider.ValidateUser(String username, String password) +83 System.Web.UI.WebControls.Login.OnAuthenticate(AuthenticateEventArgs e) +160 System.Web.UI.WebControls.Login.AttemptLogin() +105 System.Web.UI.WebControls.Login.OnBubbleEvent(Object source, EventArgs e) +99 System.Web.UI.Control.RaiseBubbleEvent(Object source, EventArgs args) +35 System.Web.UI.WebControls.Button.OnCommand(CommandEventArgs e) +115 System.Web.UI.WebControls.Button.RaisePostBackEvent(String eventArgument) +163 System.Web.UI.WebControls.Button.System.Web.UI.IPostBackEventHandler.RaisePostBackEvent(String eventArgument) +7 System.Web.UI.Page.RaisePostBackEvent(IPostBackEventHandler sourceControl, String eventArgument) +11 System.Web.UI.Page.RaisePostBackEvent(NameValueCollection postData) +33 System.Web.UI.Page.ProcessRequestMain(Boolean includeStagesBeforeAsyncPoint, Boolean includeStagesAfterAsyncPoint) +5102 ------------------------Version Information: Microsoft .NET Framework Version:2.0.50727.42; ASP.NET Version:2.0.50727.42

And the thing is im not even shure i get this error because of my SQL Express DB or if it is caused by something else. Sorry if my english is bad so if u dont get what i mean just tell me :)

|||

Hi,

You may convert your SQLExpress database to SQLServer 2005 on your local side by aspnet_regsql first. The database can be added into some management tools such as "SQLServer Management Studio". And then, you can connect to your remote SQLServer, export the lcoal database onto the one on your server. Also, you can backup the database on your local first and restore it on your server side.

Thanks.