Linked Questions

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....
3
votes
4answers
1k views

Data Migration With Different Schemas

I have a database DBv1 on a SQL Server, and I want to migrate the data in it to DBv2 (on the same box, save server). DBv2 has very similar schema. The only difference in schema is that DBv2 has one ...
0
votes
3answers
8k views

Can't restore SQL Server 2016 backup to SQL Server 2014 [duplicate]

We are having an issue at trying to restore a database: System.Data.SqlClient.SqlError: The database was backed up on a server running version 13.00.4001. That version is incompatible with this ...
4
votes
4answers
4k views

How to set 'Enable identity insert' for all the tables at once during importing data in SQL Server?

I am trying to copy a database from a remote server. I don't have access to its backups or file system. My destination database on my dev machine needs to get all the data plus the same tables ...
0
votes
0answers
87 views

SQL Server 2008 R2 warning when tried to execute the script of size approx 500MB [duplicate]

When I tried executing a SQL script, which was of 500MB approx. Management Studio throws an error Insufficient memory to continue the execution of the program My system memory is 8GB and only 3GB ...
2
votes
2answers
105 views

SQL Server: migrate one table to discrete DB server

SQL Server 2012 Standard We have one table that is highly transactional (tons of inserts, no updates), that contains a BLOB object of 5kb-300kb per row. The whole table is about 31GB in size (table ...
0
votes
1answer
534 views

Can I restore an SQL 2016 database mdf at an SQL 2014 Sp1 instance? [duplicate]

I have a database file .mdf created in SQL server 2016. I am planning to move at a new web hosting provider who supports 2014sp1 version. Should I proceed or this is out of specs? Can I restore an ...
2
votes
1answer
2k views

Attached database to SQL Server 2016 and now won't work in SQL Server 2014

I have a SQL Server 2014 database (on a portable hard drive) which I had to attach to a SQL Server 2016 machine using the normal attach method. However, since attaching it to that computer, it no ...
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
1answer
988 views

Backup & Restore Error in MS SQL Server 2016 [duplicate]

I have a backup from SQL Server 2016. I want to restore it in my pc but I am getting this error. The database was backed up on a server running version 13.00.1400. That version is incompatible ...
0
votes
1answer
91 views

Migrate Database

I'm trying to migrate my database to another server, an older version. Currently my database is on SQL Server 2014, but I need to add migrate it to SQL Server 2012 because that's the one my server has....
-2
votes
1answer
19k views

Downgrade backup from SQL Server 2014 to SQL Server 2012 [duplicate]

Im trying to restore my database on my server, but i got the following error: The database was backed up on a server running version 12.00.2269. That version is incompatible with this server, ...
1
vote
1answer
6k views

Restore a database with compression on a non-enterprise edition SQL Server

Is it possible to restore a compressed an object from backup without the Enterprise Edition? I'm getting the following error after a RESTORE DATABASE operation. Msg 3013, Level 16, State 1, Line 2 ...
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 ...
27
votes
4answers
7k views

Copying (hundreds of) tables from one server to another (with SSMS)

I have several hundred (currently 466, but ever growing) tables I have to copy from one server to another. I have never had to do this before, so I'm not sure at all on how to approach it. All the ...

15 30 50 per page