1
vote
1answer
27 views

How export database from mssql by using command line

I am using windows7 os and i have a database on MSSQL server 2005 i am using following codes to import database sqlcmd -S [server instance name] -d [database name] -i [filename you want to import] ...
1
vote
2answers
399 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
67 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
142 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
373 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 ...
3
votes
3answers
8k 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
349 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
876 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
592 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
593 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
730 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
678 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
197 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 ...