Post reply

Import limited to tables and views???

  • November 1, 2006 at 1:35 pm

    #121202

    Why is it in SQL 2005 you can only copy a table and not a stored procedure?  This causes me to do an extra step by scripting the stored procedure. 
    In SQL 2000 I can copy any object available meaning import or export to another database in one shot.
    I can even create login permissions ONLY without the stored procedures whereas in SQL 2005, I get all the CREATE statements with the object permissions.
     
    Is there something I have missed in SQL Mgmt Tools?

  • November 1, 2006 at 3:05 pm

    #669357

    In SQL 2005 you need to use "Transfer SQL Server Objects Task" of SSIS. This is having more features as compared to old import export wizard.

     

    hope this helps

    Balmukund

     

  • November 2, 2006 at 9:45 am

    #669550

    Can you tell us where to find this tool? Thanks!

  • November 7, 2006 at 7:15 am

    #670277

    Here you go.

    SQL Server 2005 Books Online
    Integration Services Tutorial

     

    Microsoft SQL Server 2005 Integration Services (SSIS) is a platform for building high performance data integration solutions, including the extraction, transformation, and load (ETL) packages for data warehousing. Integration Services includes graphical tools and wizards for building and debugging packages; tasks for performing workflow functions such as FTP operations, executing SQL statements, and sending e-mail messages; data sources and destinations for extracting and loading data; transformations for cleaning, aggregating, merging, and copying data; a management service, Integration Services Service, for administering Integration Services; and application programming interfaces (APIs) for programming the Integration Services object model.

    In this tutorial, you will learn how to use SSIS Designer to create a simple Microsoft SQL Server 2005 Integration Services package. The package that you create takes data from a flat file, reformats the data, and then inserts the reformatted data into a fact table. In following lessons, the package will be expanded to demonstrate looping, package configurations, logging and error flow.

  • November 7, 2006 at 1:00 pm

    #670377

    Thanks...but that approach is crazy and its too bad MS made these changes...they certainly didn't have the DBA in mind. 

Viewing 5 posts - 1 through 4 (of 4 total)

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