Post reply

transfer data

  • January 5, 2014 at 5:56 am

    #302398

    hi,

    i don't english good.

    i want to transfer all dat in table in windows application program in c# with sql2008 to web application delphi xe2

    with sql 2008 r2 with offline mode.whether might?

    for example i want to transfer all data in table grade student in windows application to web application with offline mode.

    i dont that where forum ask me question?

    please help me.

    best regards.

  • January 5, 2014 at 10:18 am

    #1677593

    Sql Server Integration Services (SSIS) has a lot of functions to transfer and manipulate data.

  • January 5, 2014 at 11:23 am

    #1677597

    very thanks for your guides.but i am low level and i dont sovle my problems.

    please more help me about solve problem.

    best regards

  • January 5, 2014 at 11:28 am

    #1677599

    fateme soleimani (1/5/2014)

    very thanks for your guides.but i am low level and i dont sovle my problems.

    please more help me about solve problem.

    best regards

    Understood. This isn't a trivial task, though. My best recommendation, at this point, would be to hire a consultant for a couple of days to not only accomplish this task, but to teach you how it's done so that you can maintain the process.

    --Jeff Moden

    RBAR is pronounced "ree-bar" and is a "Modenism" for Row-By-Agonizing-Row.
    First step towards the paradigm shift of writing Set Based code:
    ________Stop thinking about what you want to do to a ROW... think, instead, of what you want to do to a COLUMN.

    Change is inevitable... Change for the better is not.

    Helpful Links:
    How to post code problems
    How to Post Performance Problems
    Create a Tally Function (fnTally)

  • January 5, 2014 at 11:42 am

    #1677600

    very thanks for your guides.i will study help links.

    i want transfer all row in a table in database to web site for insert in a table in another database.

    best regards

  • January 5, 2014 at 12:02 pm

    #1677602

    Import/export wizard will do that. In Management Studio right click the source databases -> tasks-> export data

    Gail Shaw
    Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
    SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability

    We walk in the dark places no others will enter
    We stand on the bridge and no one may pass

  • January 5, 2014 at 12:17 pm

    #1677605

    very thanks for your guides.

    i will transfer rows in data to a tables in every week.in method create a table in every time.with in methoad should use sql statement?

    best regard.

  • January 5, 2014 at 12:22 pm

    #1677606

    If it's going to be weekly I'd create an SSIS package and schedule that package with SQL Agent.

    Gail Shaw
    Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
    SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability

    We walk in the dark places no others will enter
    We stand on the bridge and no one may pass

  • January 5, 2014 at 12:26 pm

    #1677607

    i am low level. what this means?

    If it's going to be weekly I'd create an SSIS package and schedule that package with SQL Agent.

    how to create ssis package?

    best regards

  • January 5, 2014 at 1:41 pm

    #1677610

    Do some reading on SSIS, it's not hard but I'm not going to walk you through it step by step. Start with the SQL help files Books Online.

    Gail Shaw
    Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
    SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability

    We walk in the dark places no others will enter
    We stand on the bridge and no one may pass

  • January 5, 2014 at 7:09 pm

    #1677631

    You can use Import/Export Wizard as Gail suggests, then when you finish setting everything, you can "SAVE" the wizard as an SSIS package that you can rerun each week.

    There are many options and choices. We do not know the details of your system, so can not give detailed help.

  • January 6, 2014 at 12:44 am

    #1677659

    very thanks for your guides.

    best regards.

  • January 14, 2014 at 9:00 am

    #1679949

    in ssis for transfer data between to deferent server that one sql and two sql online i will transfer data without connent internet. wheather transfer data in offline mode in sql server?

    in ssis in export should use .net framework for sql online. and what workstation id?

    i want to transferdata from local server to online server without connect to internet

    please help me.

    best regards

  • January 15, 2014 at 2:15 am

    #1680148

    i am low level please help me

    best regards

  • January 16, 2014 at 8:46 am

    #1680697

    i want transfer data with export in sql from local database to server data base in online mod.

    where should put address server plase help me . i want create ssis package.

    i should replication for copy data from local to server?

    how i do this?

    please help me.

    i tryed to doing this but i dont still success.

    best regards

Viewing 15 posts - 1 through 15 (of 16 total)

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