LucieLastic
Programmer
hi
I'm in the process of moving entire databases from Sybase to SQL Server 2000 and have some questions:
Q1. The DB build script I've generated in Sybase for all the DB objects include everything (constraints, indexes etc) - do I need to omit these and generate the tables on their own? Then BULK INSERT the data and add the constraints, indexes after?
Q2. Do I need to lock the table before doing the BULK INSERT?
Q3. Is there anything else I should be taking in to consideration as I'm about to try and move a pretty hefty database?
This is new to me. I've done it already with a small database but for that I had the constraints & indexes in place before doing the BULK INSERT, I also didn't lock any tables. So I'm grateful to hear of any hints, tips or suggestions.
Many thanks in advance
lou
p.s. I'm doing the move in to a development environment, so I have room for error, fortunately.
I'm in the process of moving entire databases from Sybase to SQL Server 2000 and have some questions:
Q1. The DB build script I've generated in Sybase for all the DB objects include everything (constraints, indexes etc) - do I need to omit these and generate the tables on their own? Then BULK INSERT the data and add the constraints, indexes after?
Q2. Do I need to lock the table before doing the BULK INSERT?
Q3. Is there anything else I should be taking in to consideration as I'm about to try and move a pretty hefty database?
This is new to me. I've done it already with a small database but for that I had the constraints & indexes in place before doing the BULK INSERT, I also didn't lock any tables. So I'm grateful to hear of any hints, tips or suggestions.
Many thanks in advance
lou
p.s. I'm doing the move in to a development environment, so I have room for error, fortunately.