Tagged Questions

1
vote
2answers
293 views

Possible to regularly export MS-SQL tables to another DB format on Linux without complete dumps?

We have a production server running SQL-Server, which holds our backend data, e.g., customer information, sales invoices etc. The nature of this data is that "old" data can change, e.g., a customer ...
0
votes
1answer
62 views

Transfering database from SQL Server

My old hard disk have a problem that I can't use it now and my database is currently still on it. How can I copy my database by connecting my old hard to my new laptop ? Like excel that have a file ...
2
votes
1answer
103 views

Microsoft SQL alternative for Oracle's Imp and Exp command

I'm looking a command line tool or SQL command to export/import a table or complete database. Much like the imp and exp commands of Oracle databases. Any suggestions?
0
votes
2answers
278 views

Microsoft SQL alternative for Oracle's Imp and Exp command [duplicate]

Possible Duplicate: Microsoft SQL alternative for Oracle's Imp and Exp command I'm looking a command line tool or SQL command to export/import a table or complete database. Much like ...
2
votes
3answers
7k views

MS SQL Server 2008: How to export all the tables into CSV?

I have to migrate from MS SQL Server and now creating a new ORACLE database with the data partially got from my old tables. For that I need to get the data from dozens of tables as unicode CSV or TXT ...
0
votes
1answer
308 views

How to export MS SQL database with extended properties?

I'm trying to move a MS SQL database from one provider to another, but attributes such as auto_increment for primary keys aren't copying over. I have MS SQL Server Management Studio 2008 installed, ...
2
votes
1answer
744 views

Copy the Users from one MS-SQL server to another

I am currently facing the problem that someone working here changed the password of the sa user of the Microsoft SQL Server 2005. The SQL-Server is running on a VM, and the application we run won't ...
0
votes
1answer
503 views

Mongodb export to SQL tool

Starting with monbodb. Administrators are asking a "classical" db for reporting stuff. Does it exist a tool to export documents to a relational db? Like having a flattening option or the automatic ...
1
vote
2answers
4k views

export proper csv from SqlServer management studio query result

in SqlServer management studio, you can export query results to a csv file by right click -> "Save Results as" -> csv. However, the csv file does not contain column headers and does not escape any ...
0
votes
1answer
390 views

Exporting table/view definitions for sql server 2005

I'm trying to migrate some database tables from one SQLServer2005 instance to another, by first creating the tables/views on the new server, then re-running some data import scripts. What's an easy ...
1
vote
2answers
530 views

Merging two SQL Server databases

I'd like to import data from one SQL Server DB to another. Both DBs have the same table definitions, etc. but different data. The primary keys are auto-incrementing, so the same primary key will ...
1
vote
2answers
644 views

export from Oracle into SQL Server/mySQL

I have an Oracle database which we will be removing shortly. But I would like to store some of the data somewhere else so if can be accessed if required. Is there a standard/recommended method of ...
0
votes
2answers
192 views

SQL Server 2005 — Not Able To Export Using Management Studio Express

I heard this was not available with the free express version. I need to move a moderately sized database to another computer. How can I most easily accomplish this task? We are not in a position to ...