Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
| Author |
Topic |
|
AskSQLTeam
Ask SQLTeam Question
0 Posts |
 Posted - 2004-12-13 : 08:21:55
|
| Praveen writes "I need to move/migrate data in SQL Server 2000 from 1 server to another using something called "Core Scripts batch jobs".The document that i have on Core Scripts says that it can be classified into 4 categories as1) Igniter batch2) Core batch3) Job batch4) Cartridge batch.The doc goes on to say that the directory structure for core scripts jobs needs to be setup as follows: Job scripts-> \sql\batch\<server|alias>\<db_name>Cartridge Scripts -> batch\<server|alias>\<db_name>\<Job_Name>Results/Logs-> \sql\results\<server|alias>\db_name\<Job_Name>\- Data storage-> \sql\data\<server|alias>\db_nameCan anyone throw some light as to how one can go about using these methods to migrate SQL Server tables to another server.ThanksPraveen " |
|
|
nr
SQLTeam MVY
12543 Posts |
Posted - 2004-12-13 : 08:56:10
|
| Googling for the various phrases doean't get much.Is this a product that you are trying to use or something built in-house?==========================================Cursors are useful if you don't know sql.DTS can be used in a similar way.Beer is not cold and it isn't fizzy. |
 |
|
|
X002548
Not Just a Number
15586 Posts |
Posted - 2004-12-13 : 09:49:25
|
| Yeah...forget it....Script the table sructures into 1 fileScript all the constraints into anotherbcp out all the data in native formatCopy the data files to the destination servercreate all of the table objectsbcp all the data increate all the contraintsThis HAS to be the fastest way to do this..MOOBrett8-) |
|
|
|
|
|
|
Use of Core Script jobs in SQL Server for data migration