I have the database, tables, PK's and FK's, i need to send it to the other local machine, i tried writing some query's but it failed. (Please be polite, just started :) )
Asked
Active
Viewed 46 times
0
-
https://stackoverflow.com/help/how-to-ask – jarlh Jul 09 '18 at 13:08
-
Search around for "Generate scripts". Run produced code on target machine. – George Menoutis Jul 09 '18 at 13:08
-
Also when asking a question it helps to add your script here too – connorg98 Jul 09 '18 at 13:09
-
Yes i tried that too, but i need to write it in a query, the whole database(or a certain table) :) – Limun Jul 09 '18 at 13:10
-
Oh, ok, i'll keep that in mind :0 – Limun Jul 09 '18 at 13:11
1 Answers
0
You need to be more clear on your actual goal, the question is very vague. If you are trying to transfer data from one data base to another database, which is what I assume you mean, I would highly recommend using SQL server Integration Services. You create SSIS packages in Visual Studio and it will allow you to write simple queries from your data source and insert them into the tables of the destination database. You will need to download Visual Studio and install the integration services add on. Hope this helps.
DarthTommy
- 419
- 2
- 10