Copy database to another server

Hi;
I asked this once before but can't find the info now. I need to copy a
database from one server and put it on a second server. It is Sql Server 2000
and both servers are running Windows 2003 in a workgroup (not a domain).
I want to get all of the data and meta-data across. How can I do this? (All
I remember is it is very complex because the systems are not in a domain.)
thanks - dave
david_at_windward_dot_net
http://www.windwardreports.com
Have a look at this list compiled by Andrew Kelly:
Moving DB's between Servers
http://www.support.microsoft.com/?id=314546
Moving SQL Server Databases to a New Location with Detach/Attach
http://www.support.microsoft.com/?id=224071
Using WITH MOVE in a Restore
http://support.microsoft.com/?id=221465
How To Transfer Logins and Passwords Between SQL Servers
http://www.support.microsoft.com/?id=246133
Mapping Logins & SIDs after a Restore
http://www.support.microsoft.com/?id=298897
Utility to map logins to users
http://www.dbmaint.com/SyncSql Logins.asp
User Logon and/or Permission Errors After Restoring Dump
http://www.support.microsoft.com/?id=168001
How to Resolve Permission Issues When a Database Is Moved Between SQL
Servers
http://www.support.microsoft.com/?id=240872
Restoring a .mdf
http://www.sqlservercentral.com/scri...p?scriptid=599
Disaster Recovery Articles for SQL Server
http://www.support.microsoft.com/?id=307775
Tibor Karaszi, SQL Server MVP
http://www.karaszi.com/sqlserver/default.asp
http://www.solidqualitylearning.com/
Blog: http://solidqualitylearning.com/blogs/tibor/
"David Thielen" <david@.bogus.windward.net> wrote in message
news:C8DE23AA-9CF6-46E8-8358-A998B00470EA@.microsoft.com...
> Hi;
> I asked this once before but can't find the info now. I need to copy a
> database from one server and put it on a second server. It is Sql Server 2000
> and both servers are running Windows 2003 in a workgroup (not a domain).
> I want to get all of the data and meta-data across. How can I do this? (All
> I remember is it is very complex because the systems are not in a domain.)
> --
> thanks - dave
> david_at_windward_dot_net
> http://www.windwardreports.com
>
|||Hi;
The post http://www.support.microsoft.com/kb/304692/ is for Sql Server 7
only. Is there a post somewhere for Sql Server 2000?
thanks - dave
david_at_windward_dot_net
http://www.windwardreports.com
|||Also, this post says how to restore a database - but not how to back it up.
How do I back it up?
thanks - dave
david_at_windward_dot_net
http://www.windwardreports.com
"David Thielen" wrote:

> Hi;
> The post http://www.support.microsoft.com/kb/304692/ is for Sql Server 7
> only. Is there a post somewhere for Sql Server 2000?
> --
> thanks - dave
> david_at_windward_dot_net
> http://www.windwardreports.com
>
|||A quick look suggests that this should also work for 2000, but test in a test environment first. As
for how to backup, read in Books Online about the BACKUP DATABASE command.
Tibor Karaszi, SQL Server MVP
http://www.karaszi.com/sqlserver/default.asp
http://www.solidqualitylearning.com/
Blog: http://solidqualitylearning.com/blogs/tibor/
"David Thielen" <david@.bogus.windward.net> wrote in message
news:949DC479-E52A-44BE-970F-AB64E05459AD@.microsoft.com...[vbcol=seagreen]
> Also, this post says how to restore a database - but not how to back it up.
> How do I back it up?
> --
> thanks - dave
> david_at_windward_dot_net
> http://www.windwardreports.com
>
> "David Thielen" wrote:
sqlsql

Copy database to another server

Hi;
I asked this once before but can't find the info now. I need to copy a
database from one server and put it on a second server. It is Sql Server 2000
and both servers are running Windows 2003 in a workgroup (not a domain).
I want to get all of the data and meta-data across. How can I do this? (All
I remember is it is very complex because the systems are not in a domain.)
--
thanks - dave
david_at_windward_dot_net
http://www.windwardreports.comHave a look at this list compiled by Andrew Kelly:
Moving DB's between Servers
http://www.support.microsoft.com/?id=314546
Moving SQL Server Databases to a New Location with Detach/Attach
http://www.support.microsoft.com/?id=224071
Using WITH MOVE in a Restore
http://support.microsoft.com/?id=221465
How To Transfer Logins and Passwords Between SQL Servers
http://www.support.microsoft.com/?id=246133
Mapping Logins & SIDs after a Restore
http://www.support.microsoft.com/?id=298897
Utility to map logins to users
http://www.dbmaint.com/SyncSql Logins.asp
User Logon and/or Permission Errors After Restoring Dump
http://www.support.microsoft.com/?id=168001
How to Resolve Permission Issues When a Database Is Moved Between SQL
Servers
http://www.support.microsoft.com/?id=240872
Restoring a .mdf
http://www.sqlservercentral.com/scripts/scriptdetails.asp?scriptid=599
Disaster Recovery Articles for SQL Server
http://www.support.microsoft.com/?id=307775
Tibor Karaszi, SQL Server MVP
http://www.karaszi.com/sqlserver/default.asp
http://www.solidqualitylearning.com/
Blog: http://solidqualitylearning.com/blogs/tibor/
"David Thielen" <david@.bogus.windward.net> wrote in message
news:C8DE23AA-9CF6-46E8-8358-A998B00470EA@.microsoft.com...
> Hi;
> I asked this once before but can't find the info now. I need to copy a
> database from one server and put it on a second server. It is Sql Server 2000
> and both servers are running Windows 2003 in a workgroup (not a domain).
> I want to get all of the data and meta-data across. How can I do this? (All
> I remember is it is very complex because the systems are not in a domain.)
> --
> thanks - dave
> david_at_windward_dot_net
> http://www.windwardreports.com
>|||Hi;
The post http://www.support.microsoft.com/kb/304692/ is for Sql Server 7
only. Is there a post somewhere for Sql Server 2000?
--
thanks - dave
david_at_windward_dot_net
http://www.windwardreports.com|||Also, this post says how to restore a database - but not how to back it up.
How do I back it up?
--
thanks - dave
david_at_windward_dot_net
http://www.windwardreports.com
"David Thielen" wrote:
> Hi;
> The post http://www.support.microsoft.com/kb/304692/ is for Sql Server 7
> only. Is there a post somewhere for Sql Server 2000?
> --
> thanks - dave
> david_at_windward_dot_net
> http://www.windwardreports.com
>|||A quick look suggests that this should also work for 2000, but test in a test environment first. As
for how to backup, read in Books Online about the BACKUP DATABASE command.
--
Tibor Karaszi, SQL Server MVP
http://www.karaszi.com/sqlserver/default.asp
http://www.solidqualitylearning.com/
Blog: http://solidqualitylearning.com/blogs/tibor/
"David Thielen" <david@.bogus.windward.net> wrote in message
news:949DC479-E52A-44BE-970F-AB64E05459AD@.microsoft.com...
> Also, this post says how to restore a database - but not how to back it up.
> How do I back it up?
> --
> thanks - dave
> david_at_windward_dot_net
> http://www.windwardreports.com
>
> "David Thielen" wrote:
>> Hi;
>> The post http://www.support.microsoft.com/kb/304692/ is for Sql Server 7
>> only. Is there a post somewhere for Sql Server 2000?
>> --
>> thanks - dave
>> david_at_windward_dot_net
>> http://www.windwardreports.com

Copy database to another server

Hi;
I asked this once before but can't find the info now. I need to copy a
database from one server and put it on a second server. It is Sql Server 200
0
and both servers are running Windows 2003 in a workgroup (not a domain).
I want to get all of the data and meta-data across. How can I do this? (All
I remember is it is very complex because the systems are not in a domain.)
thanks - dave
david_at_windward_dot_net
http://www.windwardreports.comHave a look at this list compiled by Andrew Kelly:
Moving DB's between Servers
http://www.support.microsoft.com/?id=314546
Moving SQL Server Databases to a New Location with Detach/Attach
http://www.support.microsoft.com/?id=224071
Using WITH MOVE in a Restore
http://support.microsoft.com/?id=221465
How To Transfer Logins and Passwords Between SQL Servers
http://www.support.microsoft.com/?id=246133
Mapping Logins & SIDs after a Restore
http://www.support.microsoft.com/?id=298897
Utility to map logins to users
http://www.dbmaint.com/SyncSql Logins.asp
User Logon and/or Permission Errors After Restoring Dump
http://www.support.microsoft.com/?id=168001
How to Resolve Permission Issues When a Database Is Moved Between SQL
Servers
http://www.support.microsoft.com/?id=240872
Restoring a .mdf
http://www.sqlservercentral.com/scr...sp?scriptid=599
Disaster Recovery Articles for SQL Server
http://www.support.microsoft.com/?id=307775
Tibor Karaszi, SQL Server MVP
http://www.karaszi.com/sqlserver/default.asp
http://www.solidqualitylearning.com/
Blog: http://solidqualitylearning.com/blogs/tibor/
"David Thielen" <david@.bogus.windward.net> wrote in message
news:C8DE23AA-9CF6-46E8-8358-A998B00470EA@.microsoft.com...
> Hi;
> I asked this once before but can't find the info now. I need to copy a
> database from one server and put it on a second server. It is Sql Server 2
000
> and both servers are running Windows 2003 in a workgroup (not a domain).
> I want to get all of the data and meta-data across. How can I do this? (Al
l
> I remember is it is very complex because the systems are not in a domain.)
> --
> thanks - dave
> david_at_windward_dot_net
> http://www.windwardreports.com
>|||Hi;
The post http://www.support.microsoft.com/kb/304692/ is for Sql Server 7
only. Is there a post somewhere for Sql Server 2000?
thanks - dave
david_at_windward_dot_net
http://www.windwardreports.com|||Also, this post says how to restore a database - but not how to back it up.
How do I back it up?
thanks - dave
david_at_windward_dot_net
http://www.windwardreports.com
"David Thielen" wrote:

> Hi;
> The post http://www.support.microsoft.com/kb/304692/ is for Sql Server 7
> only. Is there a post somewhere for Sql Server 2000?
> --
> thanks - dave
> david_at_windward_dot_net
> http://www.windwardreports.com
>|||A quick look suggests that this should also work for 2000, but test in a tes
t environment first. As
for how to backup, read in Books Online about the BACKUP DATABASE command.
Tibor Karaszi, SQL Server MVP
http://www.karaszi.com/sqlserver/default.asp
http://www.solidqualitylearning.com/
Blog: http://solidqualitylearning.com/blogs/tibor/
"David Thielen" <david@.bogus.windward.net> wrote in message
news:949DC479-E52A-44BE-970F-AB64E05459AD@.microsoft.com...[vbcol=seagreen]
> Also, this post says how to restore a database - but not how to back it up
.
> How do I back it up?
> --
> thanks - dave
> david_at_windward_dot_net
> http://www.windwardreports.com
>
> "David Thielen" wrote:
>

Copy Data from one database to another

is there any query to copy data from one database to another replacing all data in the second database

There is not a single query that will move the data from one database to another. If the databases are identically constructed, you could create a script that truncated each table and then performed a Select * from matching tables in the two databases. This can be difficult if you have used identity columns and properly implemented referential integrity.

The Data import wizard (Sql 2000) and comparable tools will move make a copy of a database.

You can also use a backup and restore.

|||

Have you looked into any of the following solutions...

SQL Server Integration Services? - http://msdn.microsoft.com/sql/bi/integration/
Copy Database Wizard (will be vastly improved in SQL Server 2005 SP2) - http://msdn2.microsoft.com/en-us/library/ms188664.aspx
Backup and Restore?

Paul A. Mestemaker II
Program Manager
Microsoft SQL Server
http://blogs.msdn.com/sqlrem/

Copy cube from a DB to another one

Hi,

I would like to copy a cube and its content from a database to another one.

The first database is the one used for production and the second will be used to archive the old cubes.

Is there a specific way to deal with this kind of issue ?

Thanks in advance for your support.

Rgds,

Juan

Hello! You have not told about what version you are using, AS2000 or SSAS2005?

With SSAS2005 you simply change this is the properties of the project and deployment.

This is in the solution explorer of BI-Developer Studio.

In AS2000 you can use archive and restore from one machine to another as long as the data source name is the same.

Regards

Thomas Ivarsson

|||In SSAS 2005, you also can try the new feature 'synchronize'.|||

I am using SSAS 2005. Can you tell me more about the "synchronize" feature.

Also, is there a way using xmla scripts ?

Cheers,

Juan

|||

You can take a look at the following link for "synchronize".

http://msdn2.microsoft.com/en-us/library/ms174928.aspx

Yes. It supports xmla script. The easy way is to generate the script using the synchronize wizard.

|||Thx !