Linked Questions
51 questions linked to/from How to move a database from SQL Server 2012 to SQL Server 2005
0
votes
2
answers
10k
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 ...
0
votes
2
answers
1k
views
migrate from sql server 2012 to sql server 2008 R2 [duplicate]
I have been looking for the information since yesterday and could not find anything...
I have sharepoint 2012 fundation and my SQL Server 2010 Evaluation is short of space (we already used 10GB), ...
0
votes
2
answers
139
views
SQL Server - creating a historical data backup
I've run out of space on my SQL Server 2008 Express DB.
i'm creating a "duplicate" SQL Server 2008 Express DB so i can backup my data before i purge my DB so i can start over. Is there a way in SQL ...
5
votes
1
answer
7k
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 ...
5
votes
1
answer
1k
views
What is the limit on the number of INSERT statements you can paste into SSMS and run?
I am currently creating a stored procedure that populates a table with a list of insert statements so that my DBAs can export the contents of the table to a text file and then paste the statements ...
3
votes
1
answer
108
views
Tool for quickly backup and restore a table
Is there a tool for quickly backup and restore a table's data, preferably to a csv file?
It would be best if I could do it using batch. Run a .cmd file and data is backed up into a file with datetime ...
3
votes
1
answer
7k
views
Downgrade database from SQL Server 2012 to 2008 [duplicate]
Hi guys got a problem with a database.
I've been asked to perform some indexing and delete queries on a live database, so first of I wanted to get the database to our dev server so I can test out ...
2
votes
1
answer
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 ...
2
votes
1
answer
9k
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
...
2
votes
1
answer
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 ...
2
votes
1
answer
133
views
Moving SQL Server 2012 Database to SQL Server 2008 R2
I follow the answer of Mr. Kin in this post
How to move a database from SQL Server 2012 to SQL Server 2005
I run the query without errors, but when I check my blank database created on SQL Server ...
1
vote
1
answer
1k
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
1
answer
368
views
Using "Generate Scripts" with EMERGENCY/SINGLE USER mode
I am trying to create an INSERT script to salvage data from a single table in a corrupt database.
I've succesfully put the database online and put it in EMERGENCY / SINGLE USER mode (following this ...
1
vote
1
answer
466
views
Copying Data to Other Database Tables
Should I use SSIS or stored procs to copy data from a number of database tables on one server to database tables on a different server?
Each table's structure is identical to the destination server ...
1
vote
1
answer
2k
views
Sql Server: how to validate schema against a textual representation (XML or the like) natively?
I need a simple "complete dump" of the schema for our repo, in human-readable format: Sprocs, Views, the like. We need to "fix" some old schema issues that cropped in over the time, and "clean up" the ...