1
vote
1answer
73 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
481 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 ...
3
votes
3answers
852 views

Export massive MySQL database, from a shared level hosting account

I need to export a huge database, with thousands of tables and millions of rows. I'm on shared hosting so I can't use command line exports, and I really have no easy way to get to this data other than ...
2
votes
1answer
64 views

How to Properly Migrate SQL

If I am changing servers, I usually migrate my wordpress database by going to phpmyadmin and doing an SQL Export on one server and doing an Import on the other server. I notice that in this process, ...
2
votes
1answer
158 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
97 views

Migration From SQL Server 2008 Express to SQL Server Web

I have SQL Server Management Studio (for SQL Server Express R2) on my pc, and I'd like to export a few databases for use by a website that's running on a server with SQL Server Web. However, when I ...
3
votes
2answers
576 views

How to handle one-way synchronization of two Oracle databases with no network connection?

Here's the situation: I have two Oracle 10g databases (with the same tables, etc.) that cannot be connected by network. At some regular intervals (say, once a day) I need to be able to update the ...
3
votes
4answers
2k views

mysqldump --where with = operator doesn't get all rows

I have a situation with a particular table that now thinks it contains 4 Petabytes of data. I know that sounds cool, but I assure you, it is only on a 60GB partition. This table has 9 fields in it. ...
0
votes
1answer
141 views

Read an InstantDB .db file

I have our database files that we've recovered from our server that was running ShopSite 7. ShopSite themselves are no help. Anyhow, I've managed to recover our orders and customers tables. ...