Post reply

Simple package

  • May 25, 2007 at 10:11 am

    #120163

    Hi,

    I am new to SSIS and I am trying to setup a simple package as follows.

    Data source: SQL Server 2000 database (want to copy all objects & data)

    Data destination: SQL Server 2005 database (this was restored from the above database backup)

    The database is very relational and we use identity property on most of our tables.

    Thanks.

    R

  • May 25, 2007 at 10:27 am

    #709030

    I found a way to do this through SSMS. Register SQL Server 2000 and select the database, then click Export Data that opens Import and Export Wizard. But there is a problem, I am not sure how to resolve. Since our database is in relational model, I am not able to truncate data and reload the data from source (getting FK constraint error). How do I go about fixing this issue.

    This was a very trivial task (copying data) between two SQL Server 2000 databases.

  • May 25, 2007 at 10:53 am

    #709039

    Check out this article on SQLIS.com -

    http://www.sqlis.com/311.aspx

     

    Tommy

    Follow @sqlscribe

  • May 28, 2007 at 12:51 am

    #709165

    Hi,

    You could also try the Microsoft SQL Server Database Publishing Wizard, which can be used to transfer all objects and data from one SQL Server to another.

    Regards

  • May 29, 2007 at 3:27 pm

    #709493

    How do I access that tool?

    Found it here,

    http://www.microsoft.com/downloads/details.aspx?familyid=56E5B1C5-BF17-42E0-A410-371A838E570A&displaylang=en

  • May 31, 2007 at 8:58 am

    #710036

    I am stuck at the point where web service needs to be created. Can someone show how to create or enable web services?

    Thanks.

  • May 31, 2007 at 9:17 pm

    #710185

    Hi,

    I suggest you use the first option (Script to file) instead of the second. The second option is to publish your database to server on the web or so.

    After creating the script (where it will script the objects as well as the data) you can run it on the target server.

    Regards.

Viewing 7 posts - 1 through 6 (of 6 total)

You must be logged in to reply to this topic. Login to reply