August 13, 2011 at 3:35 am
Hi,
we are trying to copy table data from SQL 2008 to a remote SQL Express database. The SQL 2008 table has 2.7 million record, yet when we load the bcp file file into the remote SQL Express dB, exactly half the number of records are loaded.
Has anyone any idea why this might be?
The following BCP commands were used:
bcp <dbName> out <fileName> -S<Server> -T -c
bcp <dbName> in <fileName> -S<Server> -T -c
Many thanks,
Neil
August 13, 2011 at 3:51 am
Maximum database size of 4 GB in express.
How much size the BCP data has.
Muthukkumaran Kaliyamoorthy
https://www.sqlserverblogforum.com/
August 13, 2011 at 6:52 am
Hi Muthukkumaran,
I think that you have hit the nail on the head. We created an empty database on the SQL Server Express dB, and then attempted to pre load the 2 big tables by using a BCP export from the SQL 2008 database.
The 2 BCP files generated were 3.8gB and 8.5gB respectively.
Many thanks for you help, I really appreciate it.
Neil
August 13, 2011 at 8:35 am
Exrpess 2088 R2 has a 10 GB limit, but it still seems a little too low for your needs. Maybe time to use 2 dbs.
August 15, 2011 at 4:42 am
Problem resolved by using smaller BCP files. So instead of having 1 file with 2.7 million records, instead have 3 with an even distribution.
Thanks for your help everyone.
Neil
Viewing 5 posts - 1 through 4 (of 4 total)
You must be logged in to reply to this topic. Login to reply