Linked Questions

4
votes
1answer
5k views

Transactional Replication to DB on Same Server instance

We have a SQL Server 2012 instance that contains a database with data for many product lines. We are looking for a way to take subsets of this data into another database on the same instance. This ...
0
votes
2answers
56 views

Backup / Restore of DB on MSSQL 2019 to MSSQL 2014 [duplicate]

I have a production database running on MSSQL 2019 on a hosted platform. I am wanting to create a sandbox copy of the db with all of the data in a local MSSQL server running 2014. Everything I've ...
12
votes
2answers
9k views

What's the best method to refresh only a few tables within a test database from production?

I have a very large production database and a very large test environment database in SQL Server 2008R2. Both databases have similar table structure but different users/logins/permissions/roles. I ...
2
votes
1answer
3k views

Import data from one Database to another script

As part of a data migration I would like to script a data transfer from the existing to a new database. I used to do this with DTS on older versions of MS SQL. I am currently using SQL 2012. Note the ...
1
vote
1answer
315 views

Does Azure SQL Managed Instance offer SQL Server 2016?

I want to create a SQL Server Managed Instance in Azure that is SQL Server 2016 so I can backup and restore databases across on prem and Azure - i.e. in case we want to back out of Azure, we can do a ...
1
vote
3answers
46 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....
0
votes
1answer
95 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....
3
votes
4answers
2k 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
15k 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 ...
6
votes
4answers
6k 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 ...
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
2answers
1k views

Migrate database from SQL Server 2008 Enterprise to SQL Server 2014 Standard

I need move database with "data compression" from SQL Server 2008 Enterprise to SQL Server 2014 Standard. But Standard edition does not support "data compression". How can I disable "data ...
0
votes
0answers
91 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
630 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 ...

15 30 50 per page