Problem Upsizing an Access95 table

[Keith Lee]

I have an Access95 database that I`ve been trying to port over to SQL 6.5 using the upsize wizard, I can get all the tables except one.
The message in the error log is Error 1105 Can`t allocate space for object `xxx` in database `xxxx` because the default segment is full.
If you ran out space in Syslogs dump the Transaction log ...............

The problem table has about 10000 rows. I`m not a SQL Server expert but it looks like to me there is plenty of space available.
The new SQL Server db has 15mb data size 11mb available 5mb for the Log and 5mb available, the original Access mdb file is 5mb.

Any clues on what I should do next.

[Simon Mackey]

First of all dump the transaction log cos its full. (..with no_log)
Secondly I would upsize that table without the indexes (you uncheck this option in the up/wiz)- its the indexes I`d say that are causing the problem. Then after upsizing recreate the indexes on the sql table.
If this doesnt work or isnt what your after try dumping the records to a csv file and then bcp`ing in the data to your table. (you will probably wnat to upsize it first without the data so that you just have the table structure). then in bcp your data .....
bcp yrdatabase..yrtable in datafile.csv -c -t, -b1000
this will import as char seperated by commas in batches of 1000 records at a time.
See how it goes.
If all else fails (and a simple solution) increase the log size!
Inserting bulk records creates alot of logging and despite orig size being 5Mg the Log needs more than that inserting 10000`s records with indexes.

HTH
Simon
PS Look in Book Online for help about fast and slow bcp too.
bye


On 10/27/98 11:57:16 AM, Keith Lee wrote:
> I have an Access95 database that I`ve been trying to port over to SQL 6.5
> using the upsize wizard, I can get all the tables except one.
The message
> in the error log is Error 1105 Can`t allocate space for object `xxx` in
> database `xxxx` because the default segment is full.
If you ran out space
> in Syslogs dump the Transaction log ...............

The problem table
> has about 10000 rows. I`m not a SQL Server expert but it looks like to me
> there is plenty of space available.
The new SQL Server db has 15mb data
> size 11mb available 5mb for the Log and 5mb available, the original Access
> mdb file is 5mb.

Any clues on what I should do next.

[Keith Lee]

Just a note, I tried unsuccessfully to get the Wizard to send the data to SQL Server even after
dropping the indexes etc. Finally I created a table in SQL Server, linked this new table in Access,
created an Append Query in Access and executed the query. This moved all the data successfully.

On 10/27/98 11:57:16 AM, Keith Lee wrote:
> I have an Access95 database that I`ve been trying to port over to SQL 6.5
> using the upsize wizard, I can get all the tables except one.
The message
> in the error log is Error 1105 Can`t allocate space for object `xxx` in
> database `xxxx` because the default segment is full.
If you ran out space
> in Syslogs dump the Transaction log ...............

The problem table
> has about 10000 rows. I`m not a SQL Server expert but it looks like to me
> there is plenty of space available.
The new SQL Server db has 15mb data
> size 11mb available 5mb for the Log and 5mb available, the original Access
> mdb file is 5mb.

Any clues on what I should do next.