Stack Overflow
Stack Overflow

Questions tagged [copy-database-wizard]

The Copy Database Wizard moves or copies databases between SQL Server Instances.

The Copy Database Wizard moves or copies databases and certain server objects easily from one instance of SQL Server to another instance, with no server downtime. By using this wizard, you can do the following: Pick a source and destination server. Select database(s) to move or copy. Specify the file location for the database(s). Copy logins to the destination server. Copy additional supporting objects, jobs, user-defined stored procedures, and error messages. Schedule when to move or copy the database(s).

https://msdn.microsoft.com/en-us/library/ms188664.aspx

10 questions
3
votes
1 answer

Change default destination folder for the Copy Database Wizard

Is there any possibility to change the default destination folder for the Copy Database Wizard in SQL Server Management Studio 17? Changing the database default location via the database properties does not work. This are the default paths…
Chris
  • 124
  • 9
3
votes
2 answers

SQL Server 2016 Copy Database wizard error

I'm trying to copy a SQL Server Database from sql server 2016 dev edition to SQL Server 2014 dev edition. It fails with the following log: #Fields:…
Charles Okwuagwu
  • 10,538
  • 16
  • 87
  • 157
2
votes
1 answer

Copy Azure Database Across Subscriptions

I am trying to copy my existing AzureSQL (singleton) database from PRODUCTION subscription into a NON-PRODUCTION database in a different subscription. I need to repeat this process every night so that our production support environment (non-prod)…
Sun
  • 21
  • 2
1
vote
0 answers

MongoDb Connection timeout in Azure Datafactory while Sync Data

I have created one dataset in azure datafactory for connect mongodb. While configuration i have added MongoDb connection string and it's show me connection successful. As per shown in image view After that i have configure whole pipeline with proper…
bhavik
  • 21
  • 5
1
vote
1 answer

MSSQL 2016 Package execution failed | SSIS error: Index was out of range

I've made a copy job with Copy Database Wizard using SMO(leave DB online). The DB is to be copied to the same SQL instance. This fails with The package execution failed. The step failed. If I execute the SSIS package it has created, the…
Vaskemaskina
  • 11
  • 4
0
votes
1 answer

Azure Data Factory declare a "Copy Data" reusable over pipelines

I've made a copy data object that logs process info about the pipeline into a SQL Table. This copy data activity is generic in use and can be applied to all of my pipelines... but how can i declare this specific copy data as a reusable object for…
Henk
  • 51
  • 1
  • 6
0
votes
1 answer

SQL Server Copy database wizard -w/o- logins promts error (SMO) User, group, or role 'x' already exists in the current database

I would like to copy a database from server a (2008) to b (2012). Usually I just make a backup and restore it on target. Having the feature -copy database wizard- would make my task a bit easier as I have to move quite a few dbs. I'm using the SMO…
Daniel D
  • 57
  • 9
0
votes
0 answers

SQL Server Copy Database Wizard Error: Object reference not set to an instance of an object

Trying to copy a database using Copy Database Wizard, using drop/re-attach method and getting this error. "Object reference not set to an instance of an object" error. OnInformation,SQLSERVER2017,NT…
AlexVPerl
  • 7,652
  • 8
  • 51
  • 83
0
votes
2 answers

Need a 10% Copy of my SQL Server Database for Development work

I would like to take a 10% copy of the data in a production database, keeping its integrity and restore it into a new database. Is there a method that allows this to be done in SQL Server? I have looked at creating an SSIS that exports the database…
Nutty81
  • 33
  • 4
0
votes
1 answer

Trouble with Copy Database Wizard between two SQL 2008R2 Servers

I am trying to use Copy Database Wizard to copy from my live server (shared hosting) to my local machine. Both the live and local servers are SQL 2008 R2. I have used CDW for several years with perfect success when copying from a live SQL 2000…
Billy Turtleneck
  • 55
  • 9