Post reply

SQL 2008 and 2000

  • October 20, 2009 at 6:47 am

    #212498

    I know that it is possible to run both SQL 2000 and 2008 side by side on the same computer. Can I use SPs from the 2008 DB to pull data from and write to a SQL 2000 DB?

    I have a 2008 DB communicating with a commercial application that has not upgraded to 2008 yet.

    Thanks for the help.

    Sam

  • October 20, 2009 at 7:09 am

    #1068147

    Yes you can. You can even install the SPs onto a 2000 server. You just have to make sure that you aren't using anything within the SPs that was introduced in a later version of the server that you're placing them on.

    BrainDonor.

    Steve Hall
    Linkedin
    Blog Site

  • October 20, 2009 at 7:22 am

    #1068167

    If you run SQL 2000 and SQL 2008 as separate instances, it's like they are on separate computers. There is no integration between instances.

    you can upgrade your SQL 2000 databases to 2008 by attaching them to that server. They can stay in compatibility mode 80 and function as 2000 databases. Then you can make cross database queries with stored procedures.

    If these are separate instances, your 2008 procs would need to use a linked server or OPENQUERY.

  • October 20, 2009 at 12:11 pm

    #1068423

    very much appreciate it. This means we go live with SQL 2008 this week. Thanks

    Sam

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

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