Linked Questions

0
votes
1answer
60 views

backup a specific set of tables to be moved to a remote system [duplicate]

I need to generate either backups or data dumps for about 30 tables. I want to generate a file of some sort that contains the data for these tables and transfer them to a different system. Each ...
0
votes
1answer
46 views

Export Wizard never starts Pre-executing

I'm using the Import/Export Wizard in SSMS 2012 to store some data into a flat file, as I have to move these data from one SQL server to another. I've tried with direct connecting to the server ...
1
vote
0answers
37 views

How to restore hundreds of GB database present on SQL Server 2014 to SQL Server 2008 R2 [duplicate]

I know that this was not possible as a scenario for SQL Server 2012 -> 2008 but I wonder if MS made any changes here with the 2014 version. We have SQL Server 2014 version with a fairly large ...
0
votes
0answers
35 views

Would snapshot replication avoid the “repl table shuffle” when making schema changes?

I support an application that sits upon a SQL 2008 database and has an admin tool that allows app admins to do some field customization. This issues an ALTER TABLE command when saved, and since the ...
1
vote
3answers
34 views

Copy tables selected from sys.tables to new DB

I have a DB with thousands of tables. I want to copy all tables with name like 'TableType1%' to a new DB. I can easily get a list of the tables: select * from sys.tables t where schema_name(t....

15 30 50 per page