REM Assume this directory exists:
REM C:\Program Files\Microsoft SQL Server\90\Samples\Engine\Programmability\CLR\JhuSpherical\CS\bin\debug
rem spherical lib files ---------------------------------------
copy ..\required\bin\Release\SphericalLib.dll "C:\Program Files\Microsoft SQL Server\90\Samples\Engine\Programmability\CLR\JhuSpherical\CS\bin\Release\SphericalLib.dll"
copy ..\required\bin\Debug\SphericalLib.dll "C:\Program Files\Microsoft SQL Server\90\Samples\Engine\Programmability\CLR\JhuSpherical\CS\bin\Debug\SphericalLib.dll"

rem spherical HTM  files ---------------------------------------
copy ..\CS\bin\Release\SphericalHTM.dll "C:\Program Files\Microsoft SQL Server\90\Samples\Engine\Programmability\CLR\JhuSpherical\CS\bin\Release\SphericalHTM.dll"
copy ..\CS\bin\Debug\SphericalHTM.dll "C:\Program Files\Microsoft SQL Server\90\Samples\Engine\Programmability\CLR\JhuSpherical\CS\bin\Debug\SphericalHTM.dll"
copy ..\CS\bin\Debug\SphericalHTM.pdb "C:\Program Files\Microsoft SQL Server\90\Samples\Engine\Programmability\CLR\JhuSpherical\CS\bin\Debug\SphericalHTM.pdb"
rem -----------------------------------------------
rem data files
copy ..\Data\PlaceC.dat "C:\Program Files\Microsoft SQL Server\90\Samples\Engine\Programmability\CLR\Spatial\data\PlaceC.dat"
copy ..\Data\StationC.dat "C:\Program Files\Microsoft SQL Server\90\Samples\Engine\Programmability\CLR\Spatial\data\StationC.dat"
echo "Files copied, now run spHTMCsharp.sql"
pause
